JNK

Moderator ♦ less info
meta site favicon meta user | stack exchange network profile network profile
8,565 reputation
12050
bio website
location Connecticut
age
visits member for 1 year, 11 months
seen 18 hours ago
stats profile views 644

I'm a dude.


137 Answers

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