Question : I’m trying to connect to SQL Server 2012 via DAC using Management Studio. I type admin: before my […]
Category: SQL Server
SQL Server Profiler 2005 on remote SQL Server 2008 Express?
Question : Is it possible to trace remote SQL Server 2008 using SQL Profiler 2005? If yes, does anyone know […]
Is it generally faster to select into a temp table than selecting into an actual table?
Question : I thought I once read somewhere that writing to tempdb is faster than an actual table not in […]
Maximum dataset size for a well-performing SQL Server 2012? [closed]
Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]
Isolation levels and rows not yet read
Question : Under RR in transaction T1 I do a SELECT * FROM mytable WHERE city=’London’ In another T2 I […]
How do I get the corresponding row for a RowsetID?
Question : We’re faced with the following error when a query runs against a partitioned table with Read-Only file groups: […]
SQL Server Always on Three node Cluster
Question : We have two data centers DC1 and DC2 The distance between two DC’s are about 200 miles. DC1 […]
Migrate database to Azure
Question : I have a 600GB database that I must transfer from an on-premises machine to an on Azure VM […]
Why are there Victimless Entries on the Deadlock Graph?
Question : I am trying to learn how to analyze SQL Server 2008’s deadlock graph, and I’m finding alot of […]
Is there any way to identify which SP return data
Question : I have inherited a DB (SQL Server 2016) with almost 6000 SP and no naming conventions… I have […]