Backup database in CMS
Sometime you know the database name which you want to backup, but you don't know which server it is on....
2012-05-09
1,107 reads
Generate restore script automatically by backup history table
I wrote a store procedure which could generate restore script automatically by backup history table. it can help you select...
2012-04-30
6,920 reads
Setup database mirroring and log shipping together
SQL Server has multiple high availability solutions. Comparing with cluster, database mirroring and logshipping are easier to setup, and they...
2012-04-25 (first published: 2012-04-21)
12,388 reads
script system object in resource database
When I troulbshooting the logshipping problem, I found many logshipping store procedure can not be found in the master or...
2012-04-19
1,014 reads
Log shipping setup problem
Last week, our log shipping setup had a problem, so I spent some time to dig into the log shipping....
2012-04-18
2,550 reads
Why I can not connect sql server ???
Recently, I installed sql server 2012 on windows 7 laptop, today when I wanted to login sql server with TCP/IP, I got...
2012-04-10
6,396 reads
Why shrink sql server data file failed?
Today I need to shrink a big data file, I know shrink file is not a best practise, and it...
2012-04-07
2,327 reads
Clean SQL Server Cache
I lives alone, usually, I clean my small apartment at every weekend, wipe the table/firniture with cloth, clean the capet...
2012-04-06
26,334 reads
SQL Server 2012 license
Not sure if it is a good news or bad news, SQL Server 2012 license shifts from processor-based to core-based.......here...
2012-04-05
1,936 reads
Install SQL Server 2012 Book online on local disk
After installing the SQL Server 2012 on my laptop, I found there is only online document available, no local book...
2012-04-01
25,979 reads
Blogs
SQL Server Wait Stats
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
FabCon 2025 Recap
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
Privacy Policy
We value your privacy. This policy explains what personal data we collect and why. What...
Forums
The Subtle Differences Between COALESCE and ISNULL
Comments posted to this topic are about the item The Subtle Differences Between COALESCE...
SQL Server Collations
Comments posted to this topic are about the item SQL Server Collations
Why would using a variable vs Hard Value impact a Query's Performance
Why would using variables in place of hard coded numbers impact a query's performance? ...
Question of the Day
SQL Server Collations
At what levels can we set the collation in SQL Server 2022?
See possible answers