Page 83
Index
‹
Archive Home
‹
SQL Server Archive
‹
Page 83
Archive
78
79
80
81
82
83
84
85
86
87
88
view full version:
back to formated view
1:
Advantages of SQL Server 2005 named instance?
2:
Group by With count
3:
Large DB Performance
4:
Linked Server query
5:
Dynamic Index Drop and Create
6:
Simple question
7:
Changing table value being field name
8:
Restore database status displays Loading
9:
Backup failed status = 2
10:
One data files to multiple data files.
11:
Problems in SQL, Updating many rows at once
12:
=?Utf-8?Q?problem_with_japanese_character_?=
13:
UDF syntax error on DATEADD
14:
Parse Data while selecting
15:
Scripting foreign key relationship on a table
16:
Developer Edition
17:
Unfamiliar date format
18:
String conversion to Date
19:
can this query be cleaner or written better?
20:
Date format - need help!!
21:
Copy one coulm to another
22:
Easy question about combining queries
23:
Insertion Time problem with SQLAIW32.DLL and SQLAKW32.DLL
24:
After Hours legal mp3
25:
triggers
26:
BCP data import
27:
Oracle vs. SQL Server schema compare
28:
SQL Server conversion tools
29:
Syntax error converting the varchar value
30:
Ping in sql
31:
CLR Function - Dispose() problem
32:
Error 17187
33:
CSV Scheduled Report
34:
SQL Server SP4 chat
35:
Calling a VB6 DLL from SQL-SERVER
36:
Query Analyzer Default Database
37:
SQL Down Under show 23 - James Luetkeholeter - SQL 2k5 Disaster Recovery
38:
[TCP/IP Sockets]ConnectionCheckForData()) Error
39:
An error occurred during local report processing.
40:
Index dropped after Select into
41:
Retrieve list of largest tables in a database
42:
How to find the SQL start up acct from SQL?
43:
Change the Role in log shipping
44:
Error changing part of the primary key referencing the same table
45:
Record-Tally
46:
Where clause in variable?
47:
SS2005 - Simple Query run as a sub-query returns different results
48:
Error message question..
49:
timeout error 80040e31 (sql server 2k)
50:
sp_sproc_columns.COLUMN_DEF - why is it hard-coded to NULL?
51:
XML insert
52:
Help me to fine tune this stored procedure
53:
SQL Server Instance name change
54:
SQL 2000 and Concatenating
55:
Configuring MSTSC
56:
[Microsoft][ODBC SQL Server Driver]Timeout expired
57:
SQL subquery question
58:
How to convert unicode binary into a number?
59:
sql query
60:
Order by bug?
61:
Oracle Performance Group Leverages Mercury Application Delivery Offerings
62:
Restoring from 7.0 to 2000 Enterprise Edition...
63:
Shrink and reindex ?
64:
How alter a column in a table
65:
How to solve SQL Server replication with socket?
66:
Log Shipping question
67:
all indexes lost
68:
format
69:
connections not closed by app
70:
BCP call to stored procedure - broke during upgrade from SQL 7.0 to 2000
71:
Need to find Enterprise Manager
72:
Remove ldf file
73:
bcp error handling
74:
Todd Beaulieu
75:
Unecessary update of secondary indexes?
76:
Backup Database Fails with "backup database is terminating abnormally" message
77:
Replication question
78:
problem with a join
79:
licensing violation?
80:
Some testing with IDENTITIES
81:
update permission denied on object
82:
Incorrect syntax
83:
how to quote the tabel?
84:
set ansi nulls off
85:
Statement Level Recompilation and Profiler
86:
An "EXISTS" Problem
87:
best location for the tran log?
88:
Backup and Job view and execute permissions
89:
performance issues
90:
SP4 and Shipping log
91:
Case Sensitive Comparison
92:
Sweet Loads Down the Throat
93:
About generating serial number within another field
94:
Electrical Symbols - Ohms - micro
95:
How much do "Table Views" affect server performance on a whole?
96:
Table name as the parameter in scalar valued function
97:
Colour My World
98:
unexpected return value from webservice
99:
Other ways to stop this from occuring?
100:
subgroups query
101:
Stop SQL2000 Server command lines
102:
delete problem
103:
Locking...
104:
DB permissions
105:
Tables removed from Database Diagram when schema changed
106:
Getting records for latest 4 dates
107:
How to import & export stored procedure in sql query like Table data ?
108:
Display a servers "environment"
109:
database object hierarchy
110:
Checkpoints
111:
What DLL's and Interops are required to use DSO
112:
Why are cursors Bad in Sql 2000
113:
Log Backup Job works, but reports failure.
114:
Help!!Using table hints!!!
115:
How to delete Guest user, via group membership
116:
Navistion 4.0 integration with SQL 2005
117:
Find and Delete Blanks or Characters in a Field.
118:
Local memory in ext. stored procedure.
119:
Delete Duplicate rows
120:
Old Backups not being deleted
121:
performance of select
122:
Applying criteria at the start of a series of views
123:
MS please update your Newsgroup website
124:
T-SQL limitations
125:
Changing from Windows Authentication to Mixed Mode?
126:
placing existing table on a different filegroup
127:
HELP - Query to CSV
128:
not working xp_sendmail
129:
Version Check through remote check
130:
Unable to connect to sql server after installing the ssl certifica
131:
debugging trick for odbc application
132:
where clause problem
133:
Get Identity of last record inserted.
134:
wich licence is best for me
135:
SQL Server 2005 Cost?
136:
Interface
137:
Question on table 'dtproperties'.
138:
SQL Error 2417 driving me nuts
139:
help with an inner join of parent child tables
140:
SQL Report Query
141:
What is the Log file for?
142:
Synchronise two databases... best practice?
143:
email notification
144:
SQK 2000 SP3 on Win2k3 Named Pipes Problem
145:
How to create scripts (drop then create) in sql 2005
146:
Bulk Insert
147:
Setting DCOMCNFG LaunchPermission registry value for everyone group back to "special access"
148:
User names
149:
1NF Violation?
150:
Date Wrap Around Problem
151:
Insert data from Excel to SQL server
152:
linked servers - must they be two way?
153:
COUNT two Colums from a table
154:
Partitioned view and defualt table.
155:
NDF file
156:
Is it possible to update two tables with a single statement?
157:
SQL Virtual Directory not working correctly.
158:
Problem with sql query with expression.
159:
QUERY CHALLENGE
160:
Search for key string in SP,View,etc... in all user databases
161:
Functions in Queries
162:
Need help on a SProc
163:
Perfromance issue b/w varchar and char
164:
Passing a variable to a job
165:
T-SQL Identity
166:
Need help with join query
167:
How to find longest time?
168:
SQL help from the gurus
169:
What are these "State:" numbers in error messages?
170:
How to define global var?
171:
Capatibility between 32 bit and 64 bit SQL Server 2000
172:
linked server msdb stored procedures
173:
CONVERT text to varchar
174:
cache pages > total pages
175:
for a better understanding - the table structure as script
176:
Could not create worker thread.
177:
Want to add 00 to the end of values in a table
178:
Reporting Services
179:
Error when rebuilding indexes
180:
ToolStripContainer and MDI applications?
181:
export all StoredProcedures in a TextFile
182:
autos kinder holz spielzeug holz papier pluesch tiere aus holz
183:
Trusted Connection failing for sysadmin user
184:
create a stored procedure or trigger to update a table
185:
triggers in SEM .......
186:
From integer to time
187:
How to put string variable inside EXEC
188:
Creating Database
189:
Self Join to Update Last Balance
190:
Shrinking the translogfile in SQL7 and 2000
191:
update trigger working to well
192:
Value in Variable
193:
ALTER COLUMN undocumented behavior.
194:
using cursors
195:
temp table and row number
196:
Security
197:
Debug SProcs
198:
Calling a SQL Job from a loop
199:
Locking still a problem
200:
Need help with a weird select script
201:
Intermittent problems writing records completely
202:
problem with sp_addlinkedserver
203:
why mulitple primary keys allowed in a table
204:
Query Description field?
205:
Recovery of Database 'xxx' (Complete in 68,395 more seconds)
206:
Problem with select
207:
Help with query ...
208:
SQL 2000 snafu's when upgrading to Active Directory
209:
create unique views
210:
Compare subsets
211:
DTS from 2000 to 2005
212:
SQL Server Workgroup on Windows XP Configuration
213:
Truncate Table On Linked Server?
214:
removing duplicates
215:
CPU unit in Profiler
216:
select results into file
217:
UPDATE with UNION T-SQL Problem
218:
BULK Insert
219:
localhost giving problem
220:
Error Handling in Stored Procedures
221:
SQL 2000 DB Maintenance Plan
222:
Full Text Catalog and Searching
223:
exec a .sql file
224:
Grouping question
225:
NOLOCK statement
226:
Unable to view job history
227:
Transactions and isolation levels help needed
228:
Global Datatype Edit
229:
List of foreign keys not covered by a single index?
230:
Corruption
231:
Can a CASE Staement be used in the WHERE clause
232:
SQL licensing regarding instances
233:
2 Steps in a Scheduled Job
234:
Cancaling last action
235:
Queries on a certain table not using indexes
236:
Not enough memory
237:
best way to set up development and test databases
238:
DTS packages in SQL 2005
239:
sp_helpserver Question
240:
Meta Data Services
241:
Journal table for a database
242:
how to shrink the size of tempdb other than reboot the server
243:
Debugging CLR Objects
244:
Idle Sql Agent consumes CPU
245:
Loggin Error
246:
Warning: Null value is eliminated by an aggregate or other SET operation.
247:
/3gb memory switch
248:
Condition in FROM vs WHERE
249:
Exec/Query across servers (unlinked)
250:
Union !
251:
Use of NULL and DEFAULT
252:
Is there a standard way to read a list of columns from a table?
253:
Create temporary table with dynamic SQL
254:
Unable to drop the database after dropping the republication using store procedure!!HELP !! HELP
255:
Forwarding the step1 job output to step 2
256:
Importing from Access question
257:
Retrieving the users based on server name and database
258:
Copy and move the database to another server
259:
how to simulate an array of values in a text box thru SQL
260:
Parsing comma separated or delimited values
261:
MS DTC Transaction
262:
MDF
263:
is it helpful to "Prime" a Stored Procedure?
264:
About supported by Provider Microsoft.Jet.Oledb.4.0
265:
SQLAgent on SQL 2K SP4 with SMP(4)
266:
Script Object
267:
Deleting from a table
268:
No comments allowed where creating a view?
269:
Help needed
270:
Is there a way to "select" from the results of a stored procedure?
271:
SQL Server Edition for Sharepoint Services
272:
Starting up database 'ABC'. keeps happening every second.
273:
Stored procedure to output to a file
274:
Linked servers and distributed transactions question
275:
Data driven lines with T-SQL report print outputs
276:
missing SP when I query for it's text
277:
query with table join faster?
278:
VarChar to INT conversion
279:
unable to create a recordset in vb6 from stored procedure
280:
Urgent:GROUPING Problem
281:
How to findout Eliminated record by when use Distinct function
282:
rtrim
283:
Can users be connected during a SQL backup?
284:
Help with writing a Stored Procedure
285:
Restore error - different version of the server
286:
Problems with partition view because it is evaluation version?
287:
drop database
288:
UDF - Inserting Data
289:
outer join -- losing records from parent table question
290:
Novice Query question
291:
Joe Celko's Rant Against Bit Data Types in SQL Server
292:
SQL Server 2000 and 4GB RAM
293:
Detach - Attach in SQL Server 7
294:
DTS - From Excel
295:
SQL2005 Workgroup ON 2x2 Core XEON
296:
Storing SQL in a table
297:
Can I define a query governor limit in a connection string rather then the server based option?
298:
Tables Disappeared from Enterprise Manager
299:
Index tuning wiward, 98% improvement