Viewing 15 posts - 481 through 495 (of 814 total)
Michael Valentine Jones (1/30/2012)
SQL Kiwi (1/30/2012)
...Code that has NOLOCK on every single table in every single query is an infallible indicator of poor coding, in my experience.
I mostly agree with...
February 1, 2012 at 2:42 pm
No offense intended, but when I refer to "external fragmentation", I refer to fragmentation outside of SQL Server's control; even if SQL Server reports page 1's next page is 2,...
February 1, 2012 at 2:13 pm
+1 to the suggestion on SuccessValue above, assuming the gpg is working properly.
Have you tried a more comprehensive command line, perhaps:
gpg2 --batch --encrypt --sign --local-user "Your key" --passphrase "Your passphrase"...
February 1, 2012 at 2:07 pm
Good, modern password security is often considered either "too cumbersome" for users, or "too CPU intensive"; at this point, as far as I am aware, GPGPU hashing is only aware...
January 30, 2012 at 10:30 am
GilaMonster (11/11/2011)
November 11, 2011 at 2:07 pm
dick.baker (11/11/2011)
http://ola.hallengren.com/Documentation.html#IndexOptimize
the basics are that rebuild/reorg will happen appropriate to degree of fragmentation
- once set (SQL Agent...
November 11, 2011 at 12:59 pm
Personally, if I have the space available, and the index meets my "defrag it" criteria, and I'm within my maintenance window (i.e. I have free reign to lock indexes), I...
November 10, 2011 at 1:43 pm
To add a little more hard information (taken from http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-licensing.aspx, lower right, Licensing Datasheet, and http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-editions.aspx):
Enterprise edition: OS Max cores, Per-Core licensing only, only edition with compression and partitioning (listed...
November 9, 2011 at 10:58 am
bteraberry (11/3/2011)
I agree with G^2. I would rather error on the side of reducing reads over picking the "fastest" time unless it is really disproportionate.
I agree - it's a...
November 4, 2011 at 2:35 pm
katjacurtis (10/13/2011)
I have a requirement to encrypt data using RSA, and to be able to make the public key available. I have read the following:
Check your requirement more carefully; almost...
October 21, 2011 at 11:42 am
GSquared (10/17/2011)
I'd be more inclined to go by average deviation in size, not just by average size, but average size is probably good enough. I'm lazy about it and...
October 18, 2011 at 8:15 am
GSquared (10/13/2011)
October 14, 2011 at 10:52 am
"I dropped all the foreign key constraints to this table on the handful of tables referencing it. I dropped the index, and then I added the foreign keys references back."
I...
October 10, 2011 at 11:36 am
I didn't see budget up at the top.
Tabletop exercises with surrogates are fine and dandy, but every so often you need to actually implement the critical pieces if at all...
September 26, 2011 at 9:53 am
MysteryJimbo (9/16/2011)
You're key issues are these three requirements.-350 duplicated databases
-Near Real Time
-R/W mode
- 10 to 52 Terabytes of space for the OLTP instances.
- Unknown activity; particularly, unknown peak activity (do...
September 19, 2011 at 9:56 am
Viewing 15 posts - 481 through 495 (of 814 total)