Extract default & Named Instance from @@servername
Extract default & Named Instance from @@servername.
Print all characters before and after \ to find default and named instance name.
2019-05-03 (first published: 2015-04-15)
1,118 reads
Extract default & Named Instance from @@servername.
Print all characters before and after \ to find default and named instance name.
2019-05-03 (first published: 2015-04-15)
1,118 reads
This articles describes two ways to shred Unicode Japanese character from xls files into SQL Server table using SSIS
2015-03-31
1,261 reads
This script will check if the SQL Server you are connected to is actually running.
2015-04-01 (first published: 2015-03-27)
1,736 reads
2015-03-20
1,719 reads
Learn how to remove the MDW from your SQL Server environment with the 2008, 2008 R2 and 2012 versions.
2014-09-29
4,607 reads
An alternative to tree traversal, and ultimately more efficient way to look at organizational structures is presented.
2014-09-15
7,571 reads
2014-06-27
2,260 reads
Are all RDBMS heading towards "The Cloud"? Is this something we DBAs and consultants should be doing for our client?
2014-06-05
94 reads
Constraints on a table in SQL Server are evaluated in a specific sequence. Knowing this sequence can help us leverage them to realize various business requirements.
2014-01-27
2,899 reads
A SQL Server migration with minimal business impact while synchronizing schema and data.
2013-09-23
3,355 reads
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers