Viewing 15 posts - 5,326 through 5,340 (of 49,552 total)
Scripts will only give you results when you run them.
What do you mean by 'daily'?
It has to run every day?
It has to return only one day's results?
It has...
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
July 14, 2015 at 3:41 am
BL0B_EATER (7/14/2015)
GilaMonster (7/14/2015)
BL0B_EATER (7/14/2015)
GilaMonster (7/13/2015)
Brandie Tarvin (7/13/2015)
GilaMonster (7/13/2015)
Yes, yes, yes, yes!!!!!!!!Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony
YAY!
What is...
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
July 14, 2015 at 3:39 am
A having clause is a predicate. So of the form HAVING <Expression> = <Expression>
Hence what you've got will give a syntax error
To be honest, I think more information is...
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
July 14, 2015 at 3:36 am
Please don't post multiple threads for the same problem.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1702565-392-1.aspx
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
July 14, 2015 at 3:33 am
Perfmon counter: Total server memory.
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
July 14, 2015 at 3:11 am
petermaddin (7/14/2015)
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
July 14, 2015 at 2:53 am
Maybe go ask your boss for clarification? You're not really giving us enough information on the task to help.
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
July 14, 2015 at 2:48 am
How big is the table? How many pages?
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
July 14, 2015 at 2:47 am
BL0B_EATER (7/14/2015)
GilaMonster (7/13/2015)
Brandie Tarvin (7/13/2015)
GilaMonster (7/13/2015)
Yes, yes, yes, yes!!!!!!!!Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony
YAY!
What is the degree...
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
July 14, 2015 at 2:45 am
Unless you had some monitoring, it's unlikely that you'll be able to tell what the memory usage was at a point in the past. That said, it was probably SQL...
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
July 14, 2015 at 2:38 am
SQLRNNR (7/13/2015)
GilaMonster (7/13/2015)
Yes, yes, yes, yes!!!!!!!!Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony
Congrats on the latest degree. Was this...
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
July 13, 2015 at 9:51 am
Write a select which gets the results you want. Write it so that it will return the values you want the updated table to have. Then, once you have that,...
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
July 13, 2015 at 9:38 am
Try first writing it as a select with a FROM and a derived table in the FROM clause (not a subquery in the SELECT). Once you have that correct it's...
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
July 13, 2015 at 9:18 am
As the eror states, SUM requires one parameter, you've specified two.
Sum(DayCount,0)
You need to move the ,0 to the end and add another bracket.
p.s. you can copy from inside a code...
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
July 13, 2015 at 8:30 am
mtlsql (7/12/2015)
Why are you using a table variable (with it's attendant row estimation problems) over a temp table?
What's a attendant row estimation problem? Never heard of it...
Attendant (adjective)
- being...
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
July 13, 2015 at 7:49 am
Viewing 15 posts - 5,326 through 5,340 (of 49,552 total)