Viewing 15 posts - 3,061 through 3,075 (of 49,552 total)
No, it's not automatically a bad idea, and the variable may or may not give any better estimates.
It has to do with parameter sniffing and the ability of the optimiser...
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 16, 2016 at 6:50 am
Brandie Tarvin (5/16/2016)
GilaMonster (5/16/2016)
Brandie Tarvin (5/16/2016)
Interview time!So has anyone had anything along these lines before?
My favourite was the candidate who addressed every answer to my team lead, even though 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 16, 2016 at 6:30 am
Brandie Tarvin (5/16/2016)
Interview time!So has anyone had anything along these lines before?
My favourite was the candidate who addressed every answer to my team lead, even though I was asking 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 16, 2016 at 5:55 am
Brandie Tarvin (5/16/2016)
GilaMonster (5/16/2016)
Sigh. Via PM: "Can you access my computer via Teamviewer to fix the firewall settings"Can, yes. Will, not a bloody chance in hell.
Oh, dear. I can just...
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 16, 2016 at 5:48 am
Sigh. Via PM: "Can you access my computer via Teamviewer to fix the firewall settings"
Can, yes. Will, not a bloody chance in hell.
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 16, 2016 at 5:34 am
Then you're going to have to sit and debug the network connectivity. It's probably closed ports on a firewall or similar, which is why it's going to need a local...
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 16, 2016 at 4:38 am
Speak to your network admin, or whoever set the VPN up. It's not something that random people on the internet are going to be able to fix for 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 16, 2016 at 4:29 am
tt-615680 (5/16/2016)
1. stop SQL Server Service
2. Check the location of the tempdb files
Use master
GO
SELECT name AS [LogicalName],physical_name AS [Location],state_desc AS...
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 16, 2016 at 3:35 am
Yup, entirely possible. Rolling upgrades like you describe are the only time that log shipping (or mirroring) is supported across versions.
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 16, 2016 at 3:17 am
I strongly recommend you don't leave that SQL Server accessible from the internet. Set up VPNs so that you can connect securely and ensure that random computers on the internet...
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 16, 2016 at 2:54 am
tindog (5/13/2016)
Sean Lange (5/13/2016)
tindog (5/13/2016)
Sean Lange (5/13/2016)
Luis Cazares (5/13/2016)
ChrisM@Work (5/13/2016)
Sean Lange (5/13/2016)
Brandie Tarvin (5/13/2016)
Yay.
EDIT: I should add I'm not trying to start a debate....
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 13, 2016 at 10:21 am
Imke Cronje (5/13/2016)
Unfortunately the application that connects to the database does not support clustered indexes. This is a vendor supplied database.
What?
An app shouldn't be able to tell what kind 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
May 13, 2016 at 7:18 am
Yes, it's expensive (it's re-writing the entire table), no, it's not online.
Why don't you create a clustered index on the table, then you don't have to worry about forwarded records?
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 13, 2016 at 6:44 am
How did you fail back?
What state is the secondary database 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 13, 2016 at 6:20 am
This looks like Oracle code.
While some people do know Oracle, this is a SQL Server forum (as in Microsoft SQL Server), and that's what most answers will be written for.
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 13, 2016 at 6:19 am
Viewing 15 posts - 3,061 through 3,075 (of 49,552 total)