Viewing 15 posts - 3,031 through 3,045 (of 49,571 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...
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...
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...
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...
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...
May 23, 2016 at 4:04 am
OhioGuy (5/20/2016)
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...
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....
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...
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...
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.
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.
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.
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...
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...
May 19, 2016 at 2:46 am
Viewing 15 posts - 3,031 through 3,045 (of 49,571 total)