u23432534's user avatar
u23432534's user avatar
u23432534's user avatar
u23432534
  • Member for 12 years, 1 month
  • Last seen more than a month ago
32 votes
3 answers
80k views

How to find the SQL statements that caused tempdb growth?

19 votes
4 answers
7k views

Should the index on an identity column be nonclustered?

10 votes
2 answers
26k views

alter column size take very long time?

7 votes
4 answers
3k views

The column order of composite clustered primary key on a partitioned table?

6 votes
3 answers
2k views

Why select max partitioned column is much slower than indexed one?

6 votes
2 answers
748 views

Columnstore index and low selective columns

6 votes
3 answers
3k views

Capture very expensive queries

5 votes
1 answer
289 views

sp_who returns more rows than the value of "max degree of parallelism"

5 votes
2 answers
18k views

Database cannot be opened. It is in the middle of a restore?

5 votes
1 answer
4k views

Keep original column names in SSRS report designer 3.0?

5 votes
2 answers
855 views

Make "as" mandatory when create column alias?

5 votes
2 answers
3k views

Color syntax printing in SSMS 2012

5 votes
2 answers
30k views

How to read "CPU (ms/sec)" in the "Recent Expensive Queries" of Activity Monitor?

4 votes
2 answers
4k views

Get failed SQL Server agent job?

3 votes
2 answers
668 views

Alert doesn't work?

3 votes
3 answers
5k views

Should dates in dimensional tables use dimDate?

2 votes
1 answer
583 views

Grant Windows logins to read a secondary database of log shipping?

2 votes
0 answers
51 views

Is it good to save tempdb and log files in one drive? [duplicate]

2 votes
3 answers
2k views

Force spool to avoid creating temp tables?

2 votes
3 answers
150 views

Table size and table partitioning on a single drive server

2 votes
2 answers
7k views

Why the query scan all the partitions?

1 vote
2 answers
1k views

Create multiple files for each file group for table partitioning?

1 vote
1 answer
604 views

Database which was set up for logshipping is dropped

0 votes
1 answer
232 views

Delayed transactional replication setup?

0 votes
0 answers
34 views

Check if any user uses a database? [duplicate]

0 votes
1 answer
2k views

Strange Sybase / SQL Server linked server issue

0 votes
2 answers
2k views

Grant a login of Sql server authentication the same permission of a Windows group login with Windows authentication?

0 votes
1 answer
162 views

Should I use backup compression for databases where all data is already compressed?

-1 votes
2 answers
2k views

Insert into an empty table with or without clustered primary key? [closed]