JNK

Moderator ♦ less info
meta site favicon meta user | stack exchange network profile network profile
8,951 reputation
12753
bio website
location Connecticut
age
visits member for 2 years
seen Jun 14 at 19:54
stats profile views 694

I'm a dude.


137 Answers

newest activity votes
45
Should developers be able to query production databases?
jan 6 '12 at 16:03
44
Does SQL Server read all of a COALESCE function even if the first argument is not NULL?
sep 19 '11 at 15:10
44
What's the difference between a CTE and a Temp Table?
feb 15 '12 at 16:54
28
Why do people recommend not using the name “Id” for an identity column?
apr 17 '12 at 13:41
23
Why should I create an ID column when I can use others as key fields?
nov 22 '11 at 20:04
20
Is it OK to blindly add missing indexes?
jan 19 '12 at 20:16
19
Does “WHERE 1=1” usually have an impact on query performance?
nov 16 '11 at 16:31
17
What database technologies do big search engines use?
jun 1 '12 at 12:53
15
Should date formats be specified in SQL statements?
mar 6 '12 at 21:40
13
Common Table Expression (CTE) benefits?
mar 6 '12 at 18:24
13
Why are numbers tables “invaluable”?
jan 25 '12 at 0:55
12
overstating field size in database design
aug 11 '11 at 12:47
10
Direct the OUTPUT of an UPDATE statement to a local variable
aug 17 at 15:36
10
What is the preferred method to roll out updates to hundreds of databases
apr 13 '12 at 15:20
10
Does combining columns into 1 column helps to optimize a large table?
jan 18 '12 at 14:29
10
SQL Server Partitioning - what to use for partition key?
nov 29 '11 at 20:05
10
Do empty columns take up space in a table?
aug 16 '11 at 18:07
10
datatypes in sql server , difference between similar dataypes, numeric, money , decimal ,float
apr 11 '11 at 15:13
9
How can I make my SSIS process consume more resources and run faster?
nov 21 '11 at 15:55
8
Average, between specific date/time, of the difference between current field and previous field
nov 5 at 16:51
8
Does the partition key also have to be part of the primary key?
jul 10 '12 at 17:51
8
UPDATE with JOIN on 100mm records, how to do this better? (in T-SQL)
jul 6 '12 at 15:05
8
Why is IDENTITY_INSERT ON only allowed on one table at a time?
feb 10 '12 at 19:14
8
How to get accurate query performance?
jan 20 '12 at 18:13
8
Performance of SQL Server indexing
aug 17 '11 at 10:18
7
Find “n” consecutive free numbers from table
mar 18 at 17:16
7
When should indexes be dropped and recreated?
jun 25 '12 at 19:34
7
Why index REBUILD does not reduce index fragmentatation?
may 24 '12 at 19:28
7
New table or new column
apr 9 '12 at 17:53
7
SQL Drive getting full delete millions of rows
jan 24 '12 at 19:15
1 2 3 4 5