Viewing 15 posts - 4,006 through 4,020 (of 7,167 total)
EXEC sys.sp_helptext
@objname = N'dbo.sp_help';
May 17, 2012 at 1:21 pm
eccentricDBA (5/17/2012)
opc.three (5/17/2012)
Hawkeye_DBA (5/17/2012)
I am assisting our web developer in setting up a standard for connecting to internal database servers from both inside and outside of...
May 17, 2012 at 1:15 pm
derekr 43208 (5/17/2012)
opc.three (5/17/2012)
anthony.green (5/17/2012)
No, as an index rebuild is a fully logged operation so it logs the same amount in Full or Bulk-Logged so there is no difference
Slight tweak...
May 17, 2012 at 12:57 pm
twdavis-893252 (5/17/2012)
May 17, 2012 at 12:48 pm
anthony.green (5/17/2012)
No, as an index rebuild is a fully logged operation so it logs the same amount in Full or Bulk-Logged so there is no difference
Slight tweak here. The index...
May 17, 2012 at 12:30 pm
derekr 43208 (5/17/2012)
anthony.green (5/17/2012)
May 17, 2012 at 12:26 pm
Alexeins (5/17/2012)
The only problem with this is when ColumnRef = 1000 doesn't exists, because variable still being NULL.
Did you already know the answer before you posted?
You initially asked about the...
May 17, 2012 at 12:22 pm
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:
May 17, 2012 at 12:14 pm
Hawkeye_DBA (5/17/2012)
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...
May 17, 2012 at 12:07 pm
A good system for index and stats maintenance:
SQL Server Index and Statistics Maintenance - Ola Hallengren
May 17, 2012 at 10:20 am
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...
May 17, 2012 at 9:47 am
How many validations, just missing unit_number? You might be able to set the column to NOT NULL and have BULK INSERT ignore errors.
May 17, 2012 at 8:50 am
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,...
May 17, 2012 at 8:38 am
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...
May 17, 2012 at 8:26 am
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...
May 17, 2012 at 6:19 am
Viewing 15 posts - 4,006 through 4,020 (of 7,167 total)