Database Administrators
Profile Activity
Meta user
Network profile
John Alan
Summary Answers Questions Tags Badges Bookmarks Bounties Reputation All actions

26 Answers

Votes Activity Newest
12
Splitting SQL query with many joins into smaller ones helps?
Jun 2 '13 at 9:19
9
“Access is denied” when connecting SSMS to Integration Services
Jun 4 '13 at 7:37
8
Best way to put checksum on all pages
Jul 17 '13 at 18:56
7
Is SQL Server data compression categorically good for read-only databases?
Jun 3 '13 at 7:26
6
SQL Server Linked Servers and Remote Statistics
Feb 6 '14 at 9:18
4
High number of page reads and PLE counter, but only when tracing with Profiler
Dec 25 '16 at 12:12
4
Strange behaviour DBCC Shrinkfile
May 29 '13 at 8:12
3
4 CPUs of 20 (NUMA node 0) Pegged at 100%
Dec 27 '16 at 7:07
2
SQL SERVER - Linked Server and query performance
Jun 4 '13 at 13:02
2
How to remove a database server from Utility Explorer
May 27 '13 at 17:27
2
What Problems Does an Eager Spool Indicate
May 27 '13 at 17:47
2
query processor ran out of internal resources and could not produce a query plan
May 27 '13 at 17:40
2
Why does this 120 GB insert grow the log by over 780 GB?
May 1 '13 at 15:20
1
Do BIT columns offer any performance advantages for CCIs?
Nov 17 '17 at 18:22
1
Best way to merge tightly coupled SQL Server Instances
Dec 25 '16 at 13:23
1
SSDs and 64K sectors
Dec 22 '16 at 19:43
1
Does RAM taken up Shared Memory connection counts against Max Server Memory?
Jan 31 '14 at 13:06
1
SQL Server TDE stuck encryption state 4
Jan 9 '14 at 13:33
1
What is difference between tempdb log and database log? In which circumstances these log files uses?
Jul 10 '13 at 10:10
1
interpreting how much data has been lost by analyzing dbcc output
Jun 4 '13 at 18:06
1
SQL Server clustered index high fragmentation
May 24 '13 at 13:56
1
checksum(newid()) as primary key - what happens if a collision occurs?
May 24 '13 at 7:09
0
SQL Server Trace Flag 834 on VMware
Dec 26 '16 at 11:51
0
Can we restrict the number of connections to a database in SQL Server?
Apr 1 '14 at 14:06
0
DBCC CHECKDB command creating database file with same name but with space character in extension
Jun 10 '13 at 5:50
0
Dropping and recreating indexes
May 24 '13 at 6:52

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.