Skip to main content
Akash's user avatar
Akash's user avatar
Akash's user avatar
Akash
  • Member for 11 years, 7 months
  • Last seen more than a month ago
16 votes
1 answer
2k views

Forcing an index spool

16 votes
1 answer
19k views

Why is adding a NOT NULL column with a default constraint instantaneous?

7 votes
2 answers
8k views

Should I check for existence of temp tables in Stored Procedures?

6 votes
1 answer
6k views

SQL Server job - powershell Where does "log to table" save logs

6 votes
1 answer
1k views

DBCC TRACEON (652) does not disable read ahead reads

5 votes
1 answer
246 views

Does the Query cost in Sql Server account for buffering?

4 votes
1 answer
750 views

Why is my filtered index being ignored?

3 votes
2 answers
2k views

Blocking continues after enabling snapshot isolation

3 votes
1 answer
416 views

Number of SQL Server languages

2 votes
1 answer
402 views

Deploying SSRS reports on an "Air Gapped" report server without SSDT?

2 votes
1 answer
511 views

Is it possible to deploy Microsoft PDW on Azure?

1 vote
1 answer
7k views

OUTPUT clause with UPDATE FROM

1 vote
2 answers
1k views

Bitwise operations in TSQL

1 vote
2 answers
73 views

How much work actually happens on SSMS and how much on the server itself?

0 votes
1 answer
53 views

Where are connections to databases made from when using SSRS?

0 votes
1 answer
45 views

Can I fail the current transaction from within a trigger?

0 votes
1 answer
441 views

On a single table, how is an indexed view different from a non clustered index?

0 votes
1 answer
124 views

Tools to visualize adhoc multi dimentional data