Backup Master Database
The story came from a question someone asked me.
Does Master database support full recovery mode?
As I remembered, by default,...
2012-07-07
6,086 reads
The story came from a question someone asked me.
Does Master database support full recovery mode?
As I remembered, by default,...
2012-07-07
6,086 reads
Learning new is a interesting thing. Today I read several posts regarding the SQL Server 2012 new feature:
1. Indirect Checkpoint
Prior to...
2012-07-01
2,136 reads
1. Using the OVER clause with aggregate functions
The following sample is from BOL:
-------------------------------------
USE AdventureWorks2008R2;
GO
SELECT SalesOrderID, ProductID, OrderQty
,SUM(OrderQty) OVER(PARTITION BY...
2012-06-30
2,609 reads
You can rebuild all index for a table with "Alter Index Rebuild" and "DBCC DBREINDEX" .
First, in BOL, for "DBCC...
2012-06-27 (first published: 2012-06-23)
17,761 reads
Sometimes the shrink transaction log file doesn't work.
Before we troubleshoot it, we need to know how the log file works:
Transaction...
2012-06-17
3,054 reads
Sakthivel Chidambaram recently created a calculator which can find out the max server memory value based on the input.
http://blogs.msdn.com/b/sqlsakthi/archive/2012/05/19/cool-now-we-have-a-calculator-for-finding-out-a-max-server-memory-value.aspx
you can...
2012-06-02
5,101 reads
On Windows 2008 R2, the windows firewall will turn on by default which causes connection issure for the remote client, here...
2012-06-01
5,390 reads
Here is a simple query which can list backup duration statistics for all database, including the max, min, avg of...
2012-05-25
2,743 reads
Before restoring backup, we always verify the backup file first, and run the 3 command below:
1. RESTORE HEADERONLY
Returns a result...
2012-05-17 (first published: 2012-05-12)
8,936 reads
When ad hoc queries are executed in sql server, if it is executed without parameters, and it is simple, SQL...
2012-05-15
4,890 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers