347 reputation
1311
bio website
location
age
visits member for 2 years, 10 months
seen 2 days ago

Oct
31
comment The column order of composite clustered primary key on a partitioned table?
Are you kidding? Isn't the question clear? Kenneth Fisher even gave a good answer.
Oct
31
revised The column order of composite clustered primary key on a partitioned table?
added 32 characters in body
Oct
30
revised The column order of composite clustered primary key on a partitioned table?
added 13 characters in body
Oct
30
revised The column order of composite clustered primary key on a partitioned table?
edited title
Oct
30
revised The column order of composite clustered primary key on a partitioned table?
deleted 24 characters in body; edited title
Sep
29
awarded  Notable Question
Jun
19
asked Check if any user uses a database?
Apr
22
awarded  Popular Question
Feb
22
revised Capture very expensive queries
added 5 characters in body; edited title
Feb
21
comment Capture very expensive queries
Is there any example of extended events for the purpose?
Feb
21
asked Capture very expensive queries
Nov
12
awarded  Famous Question
Nov
8
comment How to read “CPU (ms/sec)” in the “Recent Expensive Queries” of Activity Monitor?
Thanks for the answer. I did the same by check the definition of total_work_time and it's what confused me. If it reach, for example, 500, so 50% of the CPU should be busy running the query. However the process time in either performance monitoring or % Processor Time is much lower.
Nov
8
asked How to read “CPU (ms/sec)” in the “Recent Expensive Queries” of Activity Monitor?
Nov
8
revised Insert into an empty table with or without clustered primary key?
added 299 characters in body
Nov
7
comment Insert into an empty table with or without clustered primary key?
Why the question was down voted and three close requests? Isn't it a typical DBA task? Or the developer's code DBA may need to improve?
Nov
7
comment Insert into an empty table with or without clustered primary key?
Yes, this is what I thought. However, I keep reading people suggestion drop all the indexes, included the cluster indexes before insert into a new table.
Nov
7
asked Insert into an empty table with or without clustered primary key?
Nov
5
asked Make “as” mandatory when create column alias?
Oct
26
accepted Should I use backup compression for databases where all data is already compressed?