孔夫子

less info
meta site favicon meta user | stack exchange network profile network profile
2,402 reputation
121
bio website
location
age
visits member for 7 months
seen 5 hours ago
stats profile views 241

57 Answers

newest activity votes
1
Challenge. Split database 500 records in two smaller datasets, randomly
0
Extract part of string based on nth instance of character
1
Combine multiple queries into single query
1
How to backup to local drive and network drive simultaneously?
1
valid index on SQL server 2008
4
Getting sql statement to refer to more than 2 tables?
2
Getting the name of the column that was used in a join?
6
Is this table in 3NF?
3
How to flatten results of a table with two related “many” tables?
2
Shortest method to upload database to server
2
What query can give me this result?
5
Need help in converting this cursor to a set based operation
5
Unexpected Table Scan with Parameterized LIKE
0
Bitmask Flags with Lookup Tables Clarification
5
Why am I missing some output?
3
How to UPDATE a column to SET previous row value to NULL cells?
2
Why is this key lookup required?
4
Appending backups while overwriting expired sets
2
Execution plan flips Filter and Execute Scalar when using the PK, causes cast to fail
4
I need help using hierarchyid datatype and requiring a unique constraint on a varchar field
6
Is it possible to record incoming parameter values in a procedure call while tracing in SQL Server Profiler?
6
Can this SQL be made more efficient and combined into one select?
3
SQL Server Management Studio 2012: How to have folders in the SSMS project?
4
Defrag a HEAP by creating clustered index and immediately dropping it
3
How define select, if bridge pair may have 3 players?
8
Introducing an 'age' category in a patients database
5
Select the newest data (inner join + group by maybe)
2
Integrated Security Success on Master, Fails on Other Database
3
T SQL Table Valued Function to Split varbinary(max) into 16byte GUIDs
0
Previous day of last day
1 2