Set DAC port with a specific number
Usually named instance can uses dynamic port, if firewall setup on the server, you can use SQL Server Configuration Manager...
2013-04-18 (first published: 2013-04-10)
4,474 reads
Usually named instance can uses dynamic port, if firewall setup on the server, you can use SQL Server Configuration Manager...
2013-04-18 (first published: 2013-04-10)
4,474 reads
Powershell 3.0 has many new feature, and they are useful in some circumstance.
let's say User A log in server A,...
2013-04-05
1,184 reads
If you want to make you backup faster, you can try BUFFERCOUNT parameter with compression backup.
From Book Online description:
BUFFERCOUNT = { buffercount | @buffercount_variable...
2013-04-03
3,039 reads
Sometimes you just want to have a look at the system performance, or you feel tired with log on the server, open...
2013-02-21
2,049 reads
"Auto update statistics" option is enabled by default on tempdb, if it is disabled, you may get trouble in some...
2013-01-28
2,567 reads
Today I changed a sql server service startup account during testing, then when I tried to connect sql server with...
2013-01-19
12,250 reads
Below is the formula of calculating the row size of non-clustered index page
so unique non-clustered index created on unique clustered index use smallest...
2013-01-04
1,147 reads
Sometimes when you insert row on heap, even if the page has enough free space, the new row can not...
2013-01-03
933 reads
SQL Server MVP Jeremiah Peschka posted 2 articles about Hadoop, which makes me be interested on the nosql skill.
I don't have much knowledge...
2012-12-29
2,828 reads
1. Create sample db
use master
go
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 2048KB , FILEGROWTH = 1024KB...
2012-11-25
997 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Zikato
Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Comments posted to this topic are about the item SQL Standard Confusion
Comments posted to this topic are about the item SQL Standard Confusion
I am trying to create a list type report and can't seem to get...