When was the last successful backup?
What is the fastest and perhaps easiest way to find the last successful database backup?
Just right click on the Database...
2013-03-01
378 reads
What is the fastest and perhaps easiest way to find the last successful database backup?
Just right click on the Database...
2013-03-01
378 reads
Another question I have answered 100s of times to Non SQL folks. "SQLServr.Exe is consuming 80% of memory. Can you...
2012-05-20
1,353 reads
I am not sure how many of you have faced this situation? I have faced it many many times. Somebody...
2012-04-23
1,012 reads
If one needs to call a UDF or System function ( ex: Serverproperty, Getdate(), etc ) on a remote server, then one...
2012-04-08
2,655 reads
Consider the situation where one needs to store multilingual data / Special characters into a table. For example Chinese characters or...
2012-03-27
7,478 reads
What is File Group backup?
Backing up a portion of a database, say a File Group is termed as Filegroup...
2012-01-13
488 reads
Quick summary of the post:
A restoration of a full database backup retains the log file size before restoration.
Now...
2011-11-01
503 reads
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
960 reads
SQL Error log can be read from SQL Server's management studio. However, Management studio is too slow and definitely not...
2011-08-25
404 reads
Most of us would have altered a table structre by adding a column to the table. When an ALTER table...
2011-06-25
956 reads
I had an excellent group of people in Gothenburg Sweden when I taught there...
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
hi a peer of mine recalls an error in an edi app that often...
Hello SSC! First, I would like to thank everyone who has responded to my...
I have created these triggers in SQL Server 2022:
CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT AS PRINT 'one' GO CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT AS PRINT 'two' GOI want to be sure that the trigger with "1" runs first. I decide to run this:
EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'What happens? See possible answers