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
381 reads
SQL and SQL Only
SQL Server Memory Usage - Task Manager
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,423 reads
Sysprocesses CPU and CPU Percentage - utilization
I am not sure how many of you have faced this situation? I have faced it many many times. Somebody...
2012-04-23
1,224 reads
Calling Function / UDF using linked server
If one needs to call a UDF or System function ( ex: Serverproperty, Getdate(), etc ) on a remote server, then one...
2012-04-08
2,965 reads
Inserting UniCode / Special characters in tables
Consider the situation where one needs to store multilingual data / Special characters into a table. For example Chinese characters or...
2012-03-27
7,808 reads
File Group Backups - Intro
What is File Group backup?
Backing up a portion of a database, say a File Group is termed as Filegroup...
2012-01-13
492 reads
Log file size after backup and restore
Quick summary of the post:
A restoration of a full database backup retains the log file size before restoration.
Now...
2011-11-01
509 reads
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
983 reads
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
415 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
977 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers