Viewing 15 posts - 1 through 15 (of 23 total)
I agree with GaryV. The sys.dm_os_performance_counters view only provides a list of deprecated features and how often they have been used since startup. It just doesn't have much utility.
Using an...
March 8, 2021 at 5:59 pm
This is not only an interesting question but an implementation of an historically significant algorithm. Warning: it is also an extremely poorly behaved pseudo-random number generator.
The algorithm is the middle-square...
October 29, 2020 at 4:48 pm
This is a nicely written article. Perhaps more significant than representing xml in SQL Server is generating xml from SQL Server for export. Bloviated opinions about the drawbacks of xml...
April 24, 2020 at 3:02 pm
For minimal change from the existing procedure, I'd do something like this for the final queries:if @opt
December 12, 2017 at 8:53 am
December 6, 2017 at 4:26 pm
December 6, 2017 at 2:41 pm
Have you checked the generated text (for example with a hex editor) to see what the extra characters are? Are they at the beginning or end of the line. Are they...
December 1, 2017 at 11:21 am
To generate a script for the database, right-click on the database name in SSMS Object Explorer and select "Script database as...".
To generate scripts for tables, including the partition schemes and...
November 30, 2017 at 9:46 am
SQL Server dates can be cast as decimals, with the integer portion as days since 1900-01-01 00:00. The Julian date is also a decimal value of days since a base...
November 29, 2017 at 9:48 am
Since SQL Server 2008, SQL server has supported Extensible Key Management in Enterprise editions. This allows SQK encryption keys to be stored in third-party key management solutions, for example...
November 29, 2017 at 8:52 am
"Correct" answer and explanation disagree. Small 'a' is NCHAR(97).
May 6, 2016 at 9:23 am
It appears I was fooling myself. I was connecting remotely from my workstation in SSMS. I had created a (client) alias pointing to the named instance as server. I could...
September 29, 2015 at 11:15 am
Steve,
This rename can be done using sp_dropserver and sp_addserver @local='local.
I tested this on one of my development boxes that had only a single, default-named instance. First, I ran this:
sp_dropserver '<server>'
go
sp_addserver...
September 28, 2015 at 9:23 am
Many of the encryption concepts in SQL Server are pretty opaque to me. I thought the certificate was useless without its private key file. But can you create a backup...
July 12, 2013 at 8:57 am
The given answer is absolutely incorrect. http://msdn.microsoft.com/en-us/library/ms189281.aspx states explicitly how to revert to a selected snapshot if multiple snapshots exist.
1. Select the snapshot you wish to restore.
2. Drop...
July 19, 2012 at 11:40 am
Viewing 15 posts - 1 through 15 (of 23 total)