Backup/Restore vs Detach & Attach
You want to move a database from one server to another. There are two options to do that.
1) Detach/Attach: To...
2011-10-04
982 reads
Nagaraj Venkatesan
Reading SQL Error log
SQL Error log can be read from SQL Server's management studio. However, Management studio is too slow and definitely not...
2011-08-25
411 reads
ALTER TABLE - Adding Column - Column Order Impact
Most of us would have altered a table structre by adding a column to the table. When an ALTER table...
2011-06-25
973 reads
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
359 reads
Database Owner - Error Message
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
I am back again!!!. It has been ages since I posted.An important event in my life kept me away from...
2011-06-11
335 reads
Finding last database growth date and time
A file growth operation on a database server is a extremely expensive operation. Many Performance problems correlate to a Data...
2011-01-04
489 reads
Server Side trace
Most of us are aware of tracing queries using SQL profiler. But an effective way of performing tracing is using...
2010-12-24
501 reads
Perfmon counters list - Quest poster
Stumbled upon this PDF from quest which lists the important Perfmon counters and their acceptable values. A must print and...
2010-12-08
492 reads
Lock escalation : SQL Server 2008
Lock escalation is a event which occurs when SQL Server decides to upgrade a lock at a lower level hierarchy...
2010-11-29
1,321 reads
Blogs
Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
The Book of Redgate: Don’t be an a**hole
By Steve Jones
This was one of the original values: The facing page has this text: No...
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Are things getting beyond reason?
My wife apparently ask her phone a question and below is what she sent...
I Love Editorials
Comments posted to this topic are about the item I Love Editorials
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers