孔夫子

less info
meta site favicon meta user | stack exchange network profile network profile
2,415 reputation
121
bio website
location
age
visits member for 8 months
seen 1 hour ago
stats profile views 247

57 Answers

newest activity votes
2
Integrated Security Success on Master, Fails on Other Database
nov 13 at 0:55
2
Create a plan guide to cache (lazy spool) CTE result
oct 27 at 10:21
2
Conversion failure varchar to int
oct 29 at 23:06
2
Rank in more tournaments and boards
oct 28 at 22:23
2
Calculating Median Value within a Group By
oct 25 at 14:17
2
Is there a more concise way to convert a UTC datetime into a local date only?
oct 19 at 22:36
2
PIVOT SQL Server
oct 18 at 13:16
2
get query from 4 tables
oct 7 at 9:24
2
SQL Server — optimization techniques for rebuilding very large table
oct 2 at 0:34
1
Challenge. Split database 500 records in two smaller datasets, randomly
may 1 at 21:55
1
Combine multiple queries into single query
apr 25 at 11:12
1
How to backup to local drive and network drive simultaneously?
apr 25 at 11:27
1
valid index on SQL server 2008
apr 25 at 8:46
1
Converting ZIP code string to integer in SQL Server
nov 2 at 4:14
1
Save data to variable and use it in stored procedure
oct 26 at 20:48
1
Easy SQL, embedded select
oct 26 at 22:31
1
How to map another server through SQL Server Management Studio
oct 25 at 7:34
1
Query performance and join hints, plan cost, and duration
oct 24 at 20:00
1
Access query to select multiple records with matching field
oct 24 at 10:43
1
Best table schema to store daily hits for many items?
oct 8 at 9:46
0
Extract part of string based on nth instance of character
apr 26 at 3:33
0
Bitmask Flags with Lookup Tables Clarification
apr 1 at 23:55
0
Previous day of last day
nov 5 at 11:42
0
Pivoting row contents to produce one dimensional result
nov 5 at 11:38
0
I want to perform multiple date adds on a date range and select those individual dates
oct 26 at 21:19
0
remove almost duplicates based on insert time
oct 24 at 21:14
0
Many to many unique combination
oct 24 at 3:16
1 2