Viewing 15 posts - 9,151 through 9,165 (of 49,552 total)
Jeff Moden (5/3/2014)
if you use the COPY ONLY option on the NUL backup tests, the test won't interfere with the Point-In-Time backups.
You mean they won't interfere with differentials 🙂
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
May 4, 2014 at 1:14 pm
thomashohner (5/3/2014)
Anyone else sometimes feel nervous that you wont measure up?
Yup. With every new client.
I think I will give a Recursive CTE a try since I have a book...
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
May 4, 2014 at 1:10 pm
John Deupree (5/2/2014)
Can someone comment on the performance implications of using views as opposed to the tables themselves.
Depends on how complex the views are. Simple views that just narrow and/or...
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
May 4, 2014 at 1:03 pm
Jeff Moden (5/3/2014)
My feeling is that no restore would be possible from such backups.
It's not, but that's not the point.
The method he listed is how you tune backup speed. Backup...
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
May 3, 2014 at 4:37 pm
akhamoshioke (5/2/2014)
Very True Mike;The undocumented option will be to use
BACKUP LOG MyDb TO DISK=’NUL:’
Documented, just bloody stupid (the NUL device will be documented in Windows documentation since it's a OS...
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
May 3, 2014 at 11:51 am
It's always been like that for everyone. However you can't actually edit other people's posts.
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
May 2, 2014 at 2:29 am
The bug report is correct (and it's not saying that you can't edit your own post). It's saying unexpected things happen when you click the Edit on someone else's post
I...
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
May 1, 2014 at 10:37 am
Testing...
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
May 1, 2014 at 10:37 am
Doing that is pointless. Truncate deallocates all pages, Drop deallocates all pages and removes the metadata
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
May 1, 2014 at 7:36 am
M-Hol (4/30/2014)
convert your server to Virtual Machine... is the best idea.
I disagree. There's nothing magical about VMs that makes performance problems disappear, all too often it's the opposite.
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
May 1, 2014 at 7:32 am
Alexandre Araujo (4/30/2014)
Nice Gail, but hekaton is the official codename of the edition as the name of the feature.
It's not. It's the code name of what became in-memory OLTP....
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
May 1, 2014 at 7:21 am
And how long does it take to do that to a normal disk-based table?
I tested it out, with the load I could generate on a laptop I could not get...
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
April 30, 2014 at 2:17 pm
Try backups to disk, later copied to tape if/as necessary. 620GB isn't huge, backups of that size DB shouldn't take hours.
If you're having timeouts, examine the latencies and throughput of...
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
April 30, 2014 at 2:03 pm
Previously the versions had code names named after locations. Hekaton isn't a version (SQL Server 2014 is a version), hekaton is a feature and the features often get their own...
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
April 30, 2014 at 1:57 pm
Nothing so simple. It's a combination of estimated row counts, row order, whether it's a 1-1, 1-many or many-many join, parallelism, etc, etc. There are a lot of optimiser rules.
Basically...
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
April 30, 2014 at 1:45 pm
Viewing 15 posts - 9,151 through 9,165 (of 49,552 total)