Viewing 15 posts - 3,031 through 3,045 (of 49,552 total)
ThomasRushton (5/23/2016)
Been a bit quiet here over the weekend - was there an outage, or did everyone else suddenly have an attack of Real Life?
Errands (including a replacement for the...
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 23, 2016 at 2:05 pm
Need to find this without using union/union all and in one select statement.
Why this restriction?
Though, from the requirement, it doesn't sound like it needs a union or an apply. You...
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 23, 2016 at 1:23 pm
robert.sterbal 56890 (5/23/2016)
Which of these resources work best for audio only?
Pluralsight can, they're videos only, but I've listened to several courses during commute with the iPad out of sight and...
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 23, 2016 at 1:17 pm
Jeff Moden (5/23/2016)
It would appear that you only have a total of 13.3GB of log file size.
Less. The results were Total Space, Free space, not used space and free...
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 23, 2016 at 7:13 am
If they want to reduce the size of the database permanently, then they need to archive/delete data.
Don't change the autogrow settings, they're fine as they are.
Shrinking might get you...
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 23, 2016 at 4:04 am
OhioGuy (5/20/2016)
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 21, 2016 at 2:26 am
Ed Wagner (5/20/2016)
ON the SQL Saturday topic, the rumor is that a Detroit one will hopefully be scheduled for February 2017. I hope you can make it.
And further on...
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 20, 2016 at 12:55 pm
Nothing unusual there. If the data's not in cache then it has to be read in from disk, and that means PageIOLatch waits. Waits are normal, it's how SQL works....
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 20, 2016 at 4:16 am
It is possible to eliminate deadlocks in such a way that it degrades overall performance, I'm fixing a system which did just that.
In order to eliminate deadlocks on ImportantTableA, they...
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 20, 2016 at 3:16 am
Brandie Tarvin (5/19/2016)
Greg Edwards-268690 (5/19/2016)
Brandie Tarvin (5/19/2016)
GilaMonster (5/19/2016)
Lynn Pettis (5/18/2016)
Found this on my Facebook newsfeed: https://www.packtpub.com/packt/offers/data-week-2016.
Oooh. Am very tempted to grab both the R and the Data bundles.
The free 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 19, 2016 at 7:47 am
Lord Lucan (5/19/2016)
Hi,Thanks; where/how could I access the logs?
Easiest way, ask your DBA for them.
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 19, 2016 at 6:35 am
Brandie Tarvin (5/19/2016)
The alternate explanation for this behavior is some sort of security sweep that removes individual permissions.
And
along with any tables, views, stored procs etc that I have created.
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 19, 2016 at 6:34 am
Sounds like the database is getting restored from some other backup every night. Check the SQL error log for entries noting the DB has been restored.
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 19, 2016 at 5:37 am
Lynn Pettis (5/18/2016)
Found this on my Facebook newsfeed: https://www.packtpub.com/packt/offers/data-week-2016.
Oooh. Am very tempted to grab both the R and the Data bundles.
The free book yesterday (Machine Learning with R) was one...
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 19, 2016 at 2:58 am
sanjaydut26 (5/19/2016)
Seconday DB is on Standby read only mode.
Can you double-check that, because the restore error states otherwise.
The restore operation cannot proceed because the secondary database 'DB_logshipping' is not 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
May 19, 2016 at 2:46 am
Viewing 15 posts - 3,031 through 3,045 (of 49,552 total)