Viewing 15 posts - 4,381 through 4,395 (of 49,571 total)
I did say untested, try and tweak as required.
November 2, 2015 at 12:28 pm
SQThaal (11/2/2015)
If I raise an error when @fieldName isn't alphanumeric (a-Z,0-9) and/or @Value contains semicolons and/or apostrophes, am I safe?
No.
You need to whitelist (detail what is allowed), not black list....
November 2, 2015 at 12:15 pm
Typically that kind of thing is decided my marketing very close to launch. I doubt it's even decided yet, let alone made public.
November 2, 2015 at 11:04 am
Sergiy (11/1/2015)
Gail, I'm talking from experience.
Yeah, well, so am I.
Three times this year I've had to assist with the restore of a production backup to recover deleted data (2 cases)...
November 1, 2015 at 10:02 pm
We're going to have to agree to disagree here, on all of those points.
November 1, 2015 at 8:29 pm
Why?
Why keep data that we don't need to keep in detail and only need to keep in an aggregated form?
Why make the backups larger, the DB larger, the maintenance longer,...
November 1, 2015 at 7:55 pm
Sergiy (11/1/2015)
GilaMonster (11/1/2015)
Also fast data loads, fast deletes, aka the sliding window.The thing is - correct cluster index eliminates the necessity for a sliding window altogether.
I disagree.
Deleting 20 million rows...
November 1, 2015 at 7:41 pm
Jeff Moden (11/1/2015)
November 1, 2015 at 6:01 pm
JakDBA (11/1/2015)
Yes thats rite,similar Logical names are not allowed. <snip>follow the link
https://technet.microsoft.com/en-us/library/ms190447(v=sql.105).aspx
You may want to check links before you post next time. That shows how to restore with...
November 1, 2015 at 5:57 pm
It's not a problem, you'll be fine.
Logical file names only have to be unique within a database, not within an instance. Two databases with the same logical names for files...
November 1, 2015 at 5:56 pm
ben.brugman (11/1/2015)
Please explain to my the advantages of the INCLUDE?
Columns included are in the leaf level only, not the key, so the index is smaller than if they were in...
November 1, 2015 at 9:33 am
Well, colour me (not) surprised Jeff. 😉
Looks like I might need to write a part 2 of the 'query performance tuning methodology' article....
October 31, 2015 at 11:12 pm
mamianstgio (10/31/2015)
Is it possible this problem occurred because of no space on the disk?
No.
You have an IO subsystem which is not behaving correctly (writing data to disks incorrectly or writing...
October 31, 2015 at 11:03 pm
Restore from your last good backups, this is unfixable.
Cause is likely a problem in your IO subsystem.
October 31, 2015 at 10:09 am
October 30, 2015 at 3:13 pm
Viewing 15 posts - 4,381 through 4,395 (of 49,571 total)