Altering Table structure - SSMS - Timeout Expired
Altering a table using SQL Server Management Studio ( SSMS ) can be done by right clicking on the table and by...
2011-06-17
358 reads
Altering a table using SQL Server Management Studio ( SSMS ) can be done by right clicking on the table and by...
2011-06-17
358 reads
Sometimes, a simple task that as a DBA you do day in and day out,
can throw wierd errors.
You...
2011-06-12
394 reads
I am back again!!!. It has been ages since I posted.An important event in my life kept me away from...
2011-06-11
334 reads
A file growth operation on a database server is a extremely expensive operation. Many Performance problems correlate to a Data...
2011-01-04
488 reads
Most of us are aware of tracing queries using SQL profiler. But an effective way of performing tracing is using...
2010-12-24
500 reads
Stumbled upon this PDF from quest which lists the important Perfmon counters and their acceptable values. A must print and...
2010-12-08
491 reads
Lock escalation is a event which occurs when SQL Server decides to upgrade a lock at a lower level hierarchy...
2010-11-29
1,320 reads
BACKUP LOG <db_name> WITH truncate_only command, used for clearing the log file, is deprecated in SQL Server 2008. So this post will explain option...
2010-11-16
1,660 reads
The last post dealt with checking CPU pressure using wait_stats DMV. But, to get a complete picture of CPU Pressure,...
2010-11-09
781 reads
By John
Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...
By Steve Jones
As I use containers more and more to run various things, I decided I...
By Kevin3NF
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...
I maintain an application written years ago, where the database is on a Windows...
I’m working on a jewelry e-commerce project and need advice on designing an efficient...
Comments posted to this topic are about the item The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers