Viewing 15 posts - 7,426 through 7,440 (of 49,552 total)
Just to be clear, moving the report to a read only replica won't necessarily make it any faster.
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
October 23, 2014 at 11:17 am
richardm-1037631 (10/22/2014)
switch to bulk-logging, perform some intensive db activities, and then switch back to Full or Simple recovery model.
Switch to bulk-logged, perform some bulk inserts or index rebuilds...
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
October 23, 2014 at 11:08 am
Ed Wagner (10/22/2014)
GilaMonster (10/22/2014)
Ed Wagner (10/22/2014)
The one thing they have in common is slow-roasting meat of some type.A braai has nothing to do with slow roasting anything.
I guess I'll have...
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
October 22, 2014 at 11:48 am
In a real system you'd never do either of those prints in a stored proc. The application would check that a city has been selected before calling the proc 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
October 22, 2014 at 11:44 am
Ok, so we've confirmed that there are no rows for the city Greenville.
Which tab of the output are you looking at for the printed results?
Screenshot?
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
October 22, 2014 at 10:07 am
What does the query I posted return please?
I wasn't asking where in the code you were doing the IF, I can read T-SQL fine. Where are you looking when 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
October 22, 2014 at 10:01 am
Looks fine...
What does this return?
DECLARE @city varchar(20)
SELECT @City = 'Greenville'
SELECT CompanyName
FROM Customer
WHERE CompanyName IS NOT NULL
AND City = @city
UNION
SELECT CompanyName
FROM Supplier
WHERE City = @city
Also, where are you checking to see...
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
October 22, 2014 at 9:55 am
Ed Wagner (10/22/2014)
The one thing they have in common is slow-roasting meat of some type.
A braai has nothing to do with slow roasting anything.
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
October 22, 2014 at 9:48 am
Similarly, if you invite people for a braai here, there better not be just burgers, though we don't have tradition of smoking stuff.
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
October 22, 2014 at 7:51 am
Not directly, because there's no implicit conversion possible from INT to DATE.
What you can do is to add a new column with a DATE type, update it with the converted...
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
October 22, 2014 at 7:26 am
Huh?
After the restore you can add more files and filegroups, move the data around, that kind of thing. Nothing to do with generating scripts.
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
October 22, 2014 at 7:21 am
And what did a google search turn up?
It's not a term with a rigid definition
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
October 22, 2014 at 6:31 am
If you've got no stats for the problematic period, you're going to have a very hard time figuring anything out.
First place I would have looked, with monitoring, would have been...
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
October 22, 2014 at 4:50 am
ramana3327 (10/20/2014)
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
October 22, 2014 at 4:43 am
Firstly, can you clarify what you mean by 'database refresh'?
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
October 22, 2014 at 4:16 am
Viewing 15 posts - 7,426 through 7,440 (of 49,552 total)