Viewing 15 posts - 3,946 through 3,960 (of 26,490 total)
I'm confused, are you using clustering or mirroring?
April 19, 2016 at 10:23 am
nelsonj-902869 (4/15/2016)
OS - Windows 2008 R2 standard, running SQL 2008. The server has 64 GB...
April 15, 2016 at 12:40 pm
Steve Jones - SSC Editor (4/15/2016)
About to head off to SQL Saturday Phoenix. Anyone else going?
Wish I could, but don't have the PTO time since I need to take May...
April 15, 2016 at 12:07 pm
jayoub (4/15/2016)
Currently mirroring is configure on two servers
Principle SQL Server 2008 R2 SP3 (10.50.6220)
Mirrored SQL Server 2008 R2 SP3 (10.50.6000)
Will we...
April 15, 2016 at 12:05 pm
And out of curiosity, why are you trying to back door the DBA? Not a good way to influence or make friends with a DBA.
April 15, 2016 at 12:02 pm
nhansen pcc (4/15/2016)
jeff.mason (4/15/16)
https://msdn.microsoft.com/en-us/library/bb677167%28v=sql.120%29.aspx
I was starting to get excited when I read this, because it almost exactly describes the problem I was facing...
Until I got to the part that says...
April 15, 2016 at 11:54 am
Sergiy (4/14/2016)
nhansen pcc (4/11/2016)
Have you identified the corruption? has the server team looked at the drives or SAN?
Both our internal SAN team, and the vendor have looked at it,...
April 15, 2016 at 11:53 am
Phil Parkin (4/15/2016)
Anyone have a crystal ball, several hours to kill and feeling masochistic? Dive in!
Need multiple crystal balls for this one.
April 15, 2016 at 11:42 am
dan-572483 (4/15/2016)
Excuse me? Are you saying that if a database is mirrored and disk-level corruption occurs the SQL will just pull the data from the mirror??
If it can, yes....
April 15, 2016 at 11:27 am
Sergiy (4/14/2016)
Lynn Pettis (4/14/2016)
Sean Lange (4/14/2016)
Mike Frazer (4/14/2016)
Thank you...attached.Edit: I added the DDL for the related objects as scripts.txt
Those nested views are going to kill your performance something fierce....
April 14, 2016 at 7:15 pm
Sean Lange (4/14/2016)
Mike Frazer (4/14/2016)
Thank you...attached.Edit: I added the DDL for the related objects as scripts.txt
Those nested views are going to kill your performance something fierce. They seem so...
April 14, 2016 at 12:17 pm
Mike Frazer (4/14/2016)
Thank you...attached.Edit: I added the DDL for the related objects as scripts.txt
Quick look at the script file. Looks like you have nested views in the views....
April 14, 2016 at 11:53 am
To be honest, there is a lot that can be going on in this query, including some things that won't work as you expect them do work.
First, a casual glance...
April 13, 2016 at 5:01 pm
Viewing 15 posts - 3,946 through 3,960 (of 26,490 total)