18901:
need help with query
18902:
OPENDATASOURCE Authority on SQL Server 2005
18903:
Select Distinct on one field of many
18904:
Inputting a foreign key value
18905:
t-sql doc?
18906:
session (global) variable in T-SQL?
18907:
Average on a varchar fields
18908:
replace 01/01/1900 with null on select
18909:
Time interval
18910:
Left Outer Join - matching changed records?
18911:
Super manager
18912:
Imporve Performance simple query
18913:
Exporting SQL Server 2005 data to XML file
18914:
Transpose rows into columns again...
18915:
How do I do the translate from the int type to Date?
18916:
Is it possible to do this in SQL? Could be a tricky one...
18917:
Fairly complex SQL
18918:
Create backup file name with date
18919:
SSIS How to indicate parallel (concurrent processing)
18920:
SQL to mass update a table....
18921:
Verifying a linked server is pointing to something.
18922:
VS2005 CodeTemplates
18923:
Value before update in trigger
18924:
TextSize and Substring
18925:
Get the hiredate which fall in the previous month
18926:
Get data from three table and insert it in new table
18927:
checking if two sets are the same?
18928:
[SQLSTATE 01000] outputted in result file
18929:
temp tables vs other options, performance
18930:
Average and count
18931:
Speeding up a procedure
18932:
Getting the median using an SQL query
18933:
Turn Off Truncate Log Option
18934:
Help with dynamic SQL
18935:
Procedure sp_enable_sql_debug
18936:
Miserable failure deploying cube
18937:
the uniqueidentifier data type
18938:
foreign key issue...
18939:
Datetime issue in asp and asp.net files.
18940:
email list
18941:
sql server performance
18942:
Best method to get a sequence
18943:
Stored Procedure has all Default Parameters
18944:
Unicode chars
18945:
Directed Graph Problem
18946:
Running parts of sql jobs depending on date
18947:
Displaying only certain values in a field
18948:
Extended Stored Procedures Object persistance
18949:
batch update - inserted and deleted tables
18950:
SQL error
18951:
Relational "history," ala, data-audit trail
18952:
sp_addlinkedserver - Error connecting remotely to Access DB
18953:
Database Connection Problems
18954:
Wide Clustered Indexes
18955:
sp_blocker_pss80 help please
18956:
Replacing text in query
18957:
Miserable failure deploying SSAS cube
18958:
best development tool
18959:
IDENTITY as Default values
18960:
creating a script that can create OR alter a sproc?
18961:
REQ help with indexing by hand.
18962:
Where is process info :)
18963:
SQL Server 2005 and bulk inserts
18964:
conversion to datetime
18965:
How to test the stored procedure?
18966:
Agent not running for new jobs
18967:
select the last filled row before a given timestamp
18968:
using cursor in trigger
18969:
Identity specification - multiple users adding in the same table
18970:
inserting a single quote
18971:
How to get the TOP N per ID?
18972:
@@Error problem: Critical errors
18973:
object oriented stored procedure?
18974:
SQl delete problem
18975:
Transfer data
18976:
2005 EXISTS vs IN
18977:
PK to non clustered
18978:
Management Studio Execution Plan limitation
18979:
date formatting problems
18980:
passing a list of ints in a parameter
18981:
reversing "for xml" into an update
18982:
help understanding clustered indexes
18983:
recursive store procedure, need to return all rows.
18984:
problem with sp_addlinkedserver
18985:
xp_cmd.exe use
18986:
Comparison between Two Summary Queries
18987:
The TCP/IP connection to the host has failed. java.net.BindExcepti
18988:
Instead of Update trigger problem, formula fields
18989:
Wizard to generate CRUD stored procedures?
18990:
Cycles or Multiple Cascade path error
18991:
pulling data from multiple servers
18992:
Not a developer, need help with SQL syntax dealing with counters.
18993:
SQL 2000: OSQL error in batch script
18994:
SQL Query to test weather a linked server is active.
18995:
Identify groups
18996:
MS Access 2003 - SQL Server Views not filtering properly
18997:
Returning new id from sp
18998:
if statements
18999:
Subquery question
19000:
Problems importing into SQL Server 2005
19001:
the effect on nulls of using not like
19002:
Determining Table FK Dependencies
19003:
Null columns take memory?
19004:
Transaction log filling up while doing modifications to table
19005:
Incorrect syntax near the keyword 'GROUP'.
19006:
Outer Joins Performance
19007:
Problem with --> select @variable= count(distinct name) from @mytable
19008:
Problem --> select @total_unique = count(distinct name) from @mytable
19009:
shrinking
19010:
SQL 2005 SSIS - File Enumerator Missing from Foreach Loop
19011:
Full Text Search Sql 2005 freezes
19012:
0 if null 1 if not
19013:
Open "ghost" tran
19014:
caveats to using the WHERE "IN" clause with a passed in parameter in a stored procedure?
19015:
BeginTrans and CommitTrans
19016:
Manging permissions in SQL Server 7.00/2000 in the Development env
19017:
Retrieve a BLOB as .xls, vague idea...
19018:
How do I return the same row multiple times
19019:
Querying with field having multiple values with coma separated
19020:
Querying with field having multiple values with coma separated
19021:
Very deep level hierarchical tree
19022:
Grouping Question
19023:
difference
19024:
diff between function and stored proc
19025:
NEED Joins or any other better option
19026:
OUTER JOIN not working?
19027:
very large table
19028:
Use of WITH (NOLOCK) in select?
19029:
str() and equality
19030:
Use of indexed views or not?
19031:
Error converting data type varchar to numeric.
19032:
To write SPs, or not to write SPs, that is the question....
19033:
What's the best way to implement min4(v1, v2, v3, v4) in SQL 2000?
19034:
Windows User Name
19035:
Distinct Column
19036:
How do I alter table to add new columns?
19037:
Error converting data type varchar to numeric
19038:
SSIS AWDataWarehouseRefresh Package Sample
19039:
Code will not compile in 2005
19040:
UNIQUE CONSTRAINT question
19041:
SMO - How to connect and execute a script on a different server.
19042:
Query Help
19043:
Set default for null values in unmatched rows of left join
19044:
Error #-2147199229 without description
19045:
Insert rows to #temp table from ado.net table - best practice?
19046:
CLR Error moving to Production
19047:
Appending data after comparison against existing data
19048:
Constraint order
19049:
Missed Inspections During the last period.
19050:
differences between temporary table approach
19051:
SQL table copied (or linked) to MS Access
19052:
Part II: Group By Error Under SQL 2005
19053:
Why Dynamic Queries Work like that ?
19054:
Import To SQL From excel
19055:
xp_cmdshell not getting executed for FTP.
19056:
Create Database...For Attach problem with dbowner
19057:
How to cause a guaranteed lock?
19058:
Decimal Comma vs Decimal Point
19059:
Incorporating a day number in backup name
19060:
SELECT ... WHERE .. IN @DynamicList ?
19061:
UK Postcode Validation on SP Inputs
19062:
If conn_updated_any_record Then.....
19063:
Multiple Applications updating same tables
19064:
Last Record
19065:
Performance degrade after using NOLOCK ?
19066:
Performance degrade after using NOLOCK ?
19067:
DateTime Format
19068:
SELECT from list
19069:
How to pass resultset as param to SP
19070:
Need Help Please!
19071:
sp resultset to table
19072:
Development Tools
19073:
Script out multiple jobs to files (Question?)
19074:
Error with sp_send_dbmail.
19075:
Stored Procedure Question.
19076:
tables dependency
19077:
how to grant reporting services right to a non-sysadmin correctly?
19078:
Best practices for passing parameters to a 2005 stored procedure?
19079:
Item cannot be found in the collection corresponding to the reques
19080:
Help with selecting non-primary contacts
19081:
Awesome Sqlserver Information
19082:
Server is growing the swap file way to large now.
19083:
Deadlock or Parallelism issue?
19084:
Performing a Double-Redundant Insert based on conditions.
19085:
Truncate table without db_owner permission
19086:
Standby server recovery problem
19087:
Symmetric Database Encryption
19088:
Please explain this Unicode behavior
19089:
last records
19090:
Combine results from multiple queries into one
19091:
How convert NULL to empty string in select statement?
19092:
Date Field
19093:
Scheduled backups?
19094:
Using Function in Where clause
19095:
Temp Table and Dynamic SQL
19096:
Indexing Advice
19097:
How to order by lastname
19098:
Update statement reindexing database
19099:
check disk space
19100:
clean phone field
19101:
SQL Indexing error
19102:
Trigger working on SQL Server 2000 but not on SQL Server 2005
19103:
SQL Help for a novice
19104:
Update a column in top 100 rows in a table
19105:
How to ignore a MSDTC error to stop job from failing
19106:
Attaching DB & Security
19107:
Must declare the variable @user_action Error
19108:
Release locks within a transaction
19109:
what is the use of uniqueidentifier datatype
19110:
recursion when parent and child datatype is varchar
19111:
identity column
19112:
convert varchar to datetime
19113:
Slow on Server but fast on local pc
19114:
Instead of SELECT TOP 10 - SELECT Range 0-10 or 20-30 and so on?
19115:
Newbie, construct an email message help
19116:
SQL Server 2000
19117:
Joining two sets of INNER JOINs with an OUTER JOIN
19118:
Create Partition Function incorrect Syntax
19119:
Help with Select
19120:
Using a datetime value in a select by group by the month
19121:
2 digits in DAY?
19122:
Continous running processes is it a bug?
19123:
Getting back set order from the IN param
19124:
Permission problem with a SP in which running sqlexecute
19125:
Implications of having no clustered indexes on a table?
19126:
Storing Binary Data in SQL 2005 : Can SQL Compress automatically?
19127:
ROWCOUNT as Output Parameter
19128:
Getting Index/PK or Unique Keys information - INFORMATION_SCHEMA
19129:
Security Group Members
19130:
arithmetic problem!
19131:
Looking for Work.
19132:
Query problem
19133:
Beginner Problem with GROUP by
19134:
Stored Procedure/Function question with SQL Server 2005
19135:
How to Catch User Raised Error In SQL Server 2000?
19136:
Parent - child plus new table
19137:
Using DIFFERENCE with an index?
19138:
Delete from 2 tables
19139:
about cursor
19140:
question about #temp tables from ado.net
19141:
Dividing
19142:
DTS Security
19143:
Stored Procedure Size
19144:
SQL Server 2005
19145:
UnInspected Items Report!!
19146:
Rename Table - Dependent Objects Broken
19147:
quick way to compare security
19148:
Deleting over million Rows
19149:
Update statement really slow
19150:
Connection string "Connect Timeout=600; " doesn't work
19151:
I can not create a deadlock
19152:
dumb question: tsql line termination
19153:
Automatic Date Update
19154:
SP_EXECUTESQL problems.
19155:
selecting fields within trigger inserted and deleted tables
19156:
How to release in ASP.NET code?
19157:
Define a column in a where clause dynamically
19158:
xp_cmdshell question
19159:
Compare table definitions?
19160:
CROSS JOIN question
19161:
SQL SERVER 2005 & SAGE MMS DATA BASE TABLE JOINING & UPDATING
19162:
What does the capital N before the string do in a Stored Procedure?
19163:
Need help with a query - finding latest record
19164:
.NET Stored procedures and error raiseing
19165:
Need help with a query
19166:
Combine multiple databases into same backup set.
19167:
Error with OpenRowset
19168:
Global trigger
19169:
auto update of datetime field
19170:
No. of Rows in Deleted, Inserted and Updated tableds in Triggers
19171:
how to use quotes in ASP and SQLcmd?
19172:
Stored proc migration
19173:
SQL query
19174:
SQL Server Text file Import
19175:
Trying to return new id
19176:
Schedule to new day
19177:
reading multiple result sets: select * from sp_help tbx
19178:
Stored proc missing parameters
19179:
assign id during bulk insert operation
19180:
Trigger newbie : Syntax, structure, etc.
19181:
Append Data To Field Via Loop
19182:
looking for beta testers: new SQL comparison tool
19183:
Help - Appending Data To a Field (via loop)
19184:
Foreign Key Strategy (Optional Columns)
19185:
Error Trapping
19186:
Red Gate Survey: Database Development (versioning/source control)
19187:
INFORMATION_SCHEMA.ROUTINES does not return entire procedure text
19188:
SELECT in a Constraint?
19189:
problem with returning highest numeric value in a column that may also contain text data
19190:
Optimize query with many NOT IN
19191:
Table return function question
19192:
Best way to merge or join data from results set
19193:
Case When Then question
19194:
SHAPE command
19195:
Multi-Table Stored Procedure Insert
19196:
Syntax Error in SQL
19197:
Update Query Speed Issue
19198:
Network packet size
19199:
Add same server to EM multiple times solution
19200:
"Order By" runs very slow with compatibility level 80
19201:
pivot table
19202:
Problem with MS DTC and remote table with join local memory table
19203:
Do not strip noise words
19204:
error handling to stop job from failing
19205:
LEFT JOIN question
19206:
Bubbling up error messages: Nested Stored Procs
19207:
query to return the highest of a group of calculated totals
19208:
generate serial number
19209:
Need DTS help fast; writing filename along with data
19210:
select * from sp_databases ??? How to read result set in TransactS
19211:
Updatable cursor not working with Order By when I need select in a specified SORT order
19212:
Left Outer Join not showing records for left table when right blan
19213:
String comparison performance problems
19214:
Unique records query
19215:
Stored procedure to change not nulls to nulls
19216:
Exchange Standard ~ Enterprise
19217:
Attaching a database in SQL 2005
19218:
System query for maintenance plans
19219:
Why SQL server suddenly lost its performance?
19220:
How to convert rows to columns in Select statement
19221:
Blocking on a resource
19222:
Date Difference
19223:
Encryption
19224:
Re: Can you use TOP, GROUP BY, ORDER BY or use HAVING within an EXISTS subquery?
19225:
owners of databases
19226:
indexed partitioned view?
19227:
Pass Ampersand in Parameter
19228:
Create automatically RSS xml save to file from SQL Server 20005?
19229:
Merging very big tables
19230:
Formatting columns in datagrid
19231:
Multiple Databases?
19232:
Carriage Returns and Line Feeds in Sql Server Tables
19233:
Stored Procedure Help (Urgent)
19234:
Set default db in Query Analyzer?
19235:
Clean up sql server cache
19236:
Backup Maint plan and multi-file backup
19237:
using IN when value could be null
19238:
set column to NOT NULL not working
19239:
Execute sql job from t-sql
19240:
Data not showing
19241:
Strange behaviour when using IMAGE datatype for stroring jpeg's or
19242:
Help error 1326
19243:
cascade delete question
19244:
Multiple table query.
19245:
finding dependencies with sp_depends.
19246:
SELECT...INTO to Linked Server
19247:
Identity Block Reserved for Inserts - Are you good?
19248:
Scripting Jobs
19249:
Help with SELECT TOP PERCENT.
19250:
When to use views.