Viewing 15 posts - 1,546 through 1,560 (of 5,843 total)
SQLRNNR (4/30/2015)
Ed Wagner (4/30/2015)
TheSQLGuru (4/30/2015)
This is coming from the Database Manager at our new company.
That seems to have been missed. Sadly it is MANAGEMENT/LEADERSHIP that is forcing these ridiculous...
April 30, 2015 at 7:49 am
This is coming from the Database Manager at our new company.
That seems to have been missed. Sadly it is MANAGEMENT/LEADERSHIP that is forcing these ridiculous requirements, not some Jr....
April 30, 2015 at 6:22 am
Steve Vassallo (4/29/2015)
April 29, 2015 at 3:06 pm
Lynn Pettis (4/28/2015)
TheSQLGuru (4/28/2015)
Oh, the MOST obvious possible cause: Your Secondary is a fraction of the power (CPU/RAM/IO/etc) that your Primary is!! :hehe:
From the original post:
- Identical hardware between principal...
April 28, 2015 at 10:56 am
Oh, the MOST obvious possible cause: Your Secondary is a fraction of the power (CPU/RAM/IO/etc) that your Primary is!! :hehe:
April 28, 2015 at 10:16 am
What form of troubleshooting did you do on the database server itself??
1) use sp_whoisactive to find causes of calls not completing in a timely manner (locking/blocking, system processes running, query...
April 28, 2015 at 7:33 am
Igor Micev (4/28/2015)
Grant Fritchey (4/27/2015)
TheSQLGuru (4/27/2015)
Igor Micev (4/27/2015)
You can use the NOLOCK hint for srno without worries because u're reading an identity value.Can you please explain that statement Igor??
Yeah. I'm...
April 28, 2015 at 7:26 am
Igor Micev (4/27/2015)
You can use the NOLOCK hint for srno without worries because u're reading an identity value.
Can you please explain that statement Igor??
April 27, 2015 at 2:35 pm
MANY things could be at fault here:
1) triggers doing bad stuff
2) constraints doing bad stuff
3) blocking by other activity (I go with this by default for a 60K row tale...
April 27, 2015 at 8:18 am
BEWARE the Scalar UDF though!! It has MANY downsides, including voiding the use of parallelism, preventing accurate estimates but the optimizer (with associated bad performance and bad concurrency), often forcing...
April 22, 2015 at 9:42 am
GAH!! That's what I get for (again) trying to answer questions with significant jet lag! 🙁
April 20, 2015 at 1:06 pm
In addition to what Gail offered, there are a number of options for DBCC PAGE, and I think you can get a more detailed set of output that could be...
April 20, 2015 at 9:31 am
As long as when primary and secondary are running the SQL Server service and SQL Agent are running they will fire their respective jobs and do what they are supposed...
April 20, 2015 at 8:00 am
Stan_Segers (4/15/2015)
@kevin, hopefully your jet-lag will quickly fade... I very much care about those details. The current SQL 2012 is at...
April 16, 2015 at 3:36 am
Viewing 15 posts - 1,546 through 1,560 (of 5,843 total)