Cumulative Update – 15 for SQL Server 2012 Service Pack 1 Is Now Available !
The 15th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2015-04-27
649 reads
MSSQLFUN
Cumulative Update – 7 for SQL Server 2014 RTM Is Now Available !
The 7th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site....
2015-04-27
1,782 reads
Window Server 2008 Failover Clustering Logs
In Windows 2003 failover clustering, Cluster nodes continuously putting details in log file on each node. This log is in readable plain text format & located in %SystemRoot%Cluster folder...
2015-04-24
13 reads
Window Server 2008 Failover Clustering Logs
In Windows 2003 failover clustering, Cluster nodes continuously putting details in log file on each node. This log is in...
2015-04-24
4,769 reads
How to restore Master database – SQL Server System Database?
Steps to restore SQL Server Master Database :- 1) Stop SQL Server Services 2) Add [-m] startup parameter in SQL Services from configuration manager Parameter [-m] Starts SQL Server...
2015-04-13
3 reads
How to restore Master database – SQL Server System Database?
Steps to restore SQL Server Master Database :-
1) Stop SQL Server Services
2) Add [-m] startup parameter in SQL Services from...
2015-04-23 (first published: 2015-04-13)
6,509 reads
How to move Resource DB in SQL Server ?
The Resource database is a read-only database that contains all the system objects. This DB included with SQL Server 2005 to increase security of system metadata. SQL Server system...
2015-04-08
6 reads
How to move Resource DB in SQL Server ?
The Resource database is a read-only database that contains all the system objects. This DB included with SQL Server 2005...
2015-04-08
1,775 reads
How to Rebuild MSDB database?
I suggest to have regular full backup of your system database along with user database. But if you do not have system database & your MSDB got corrupted then...
2015-02-02
2 reads
How to Rebuild MSDB database?
I suggest to have regular full backup of your system database along with user database. But if you do not...
2015-02-02
10,556 reads
Blogs
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Forums
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Eight Minutes
Comments posted to this topic are about the item Eight Minutes
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?