eccentricDBA (5/17/2012)

---

opc.three (5/17/2012)

---

Hawkeye_DBA (5/17/2012)

---

Hello SQL Server Central friends,

I am assisting our web developer in setting up a standard for connecting to internal database servers from both inside and outside of...

derekr 43208 (5/17/2012)

---

opc.three (5/17/2012)

---

Slight tweak...

twdavis-893252 (5/17/2012)

---

Thanks do you use this how long does it take to run(how many tables do you run it on) and do you run it while users on on the...

Slight tweak here. The index...

derekr 43208 (5/17/2012)

---

anthony.green (5/17/2012)

---

secondary server is generally in norecovery mode so no users, so no load on the database so can usually do things quicker as its not serving user...

Did you already know the answer before you posted?

You initially asked about the...

I almost forgot, if you end up relying on NTLM make sure your OS is patched. Security holes in pass-through auth (leverages NTLM) existed until recently:

Microsoft Security Bulletin MS10-012 -...

Hawkeye_DBA (5/17/2012)

---

Hello SQL Server Central friends,

I am assisting our web developer in setting up a standard for connecting to internal database servers from both inside and outside of the DMZ.

Currently...

A good system for index and stats maintenance:

SQL Server Index and Statistics Maintenance - Ola Hallengren

Seriously...get this person some PowerShell 😎

Add-Type -AssemblyName “Microsoft.SqlServer.Smo”

##################################################################

# initialize variables

$instanceName = "myserver\myinstancename"

$databaseName = "mydatabase"

$login = "testlogin" # leave blank to use Windows Authentication

$password = "password"

$sql = "delete FROM WebProxyLog WHERE...

How many validations, just missing unit_number? You might be able to set the column to NOT NULL and have BULK INSERT ignore errors.

Pick a column in your table and create a persisted computed column off it using the HASHBYTES function:

ALTER TABLE dbo.[TableName]

ADD [HashedColumnName] AS CAST(HASHBYTES('MD5',CAST([ExistingColumnName] AS VARCHAR(40))) AS VARBINARY(40))

PERSISTED -- important,...

XML is a great way to genericize a payload in this instance since it will vary from one table to the next. Logging all DML operations to a single table...

I did not have time to test it, i may later today, but I am referring to Kristian's post as to why I am thinking it pertains to index operations...

I can see where you would go there for indexes though you swept queries into your...