Viewing 15 posts - 4,381 through 4,395 (of 49,552 total)
I did say untested, try and tweak as required.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2015 at 10:02 pm
We're going to have to agree to disagree here, on all of those points.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2015 at 7:41 pm
Jeff Moden (11/1/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2015 at 10:09 am
http://www.sqlservercentral.com/Forums/Topic359034-8-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 30, 2015 at 3:13 pm
Viewing 15 posts - 4,381 through 4,395 (of 49,552 total)