Viewing 15 posts - 19,141 through 19,155 (of 19,560 total)
Try using a replace.
replace('"Term: Fall 2009 Subject: EDCI; Course: 257 Sensory Motor Sec: LL; Will Use Calendar"',';','-')
or some character that will not cause you the grief.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 13, 2009 at 10:27 am
Agree, the answer to that question is - "It depends"
If we are using RBAR, on a 386, with 256MB Ram - I'm sure we could bring the house down with...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 13, 2009 at 10:25 am
Same as Lynn said, with a reference
http://www.mssqltips.com/tip.asp?tip=1044
This article discusses the method you are using. The base idea is to do a rowcount without the table scan.
Here are a couple...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 13, 2009 at 10:00 am
ROFLMAOTMGH
...TMGH = til my gut hurts
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 12, 2009 at 8:42 pm
Once you eliminate the date cast(floor(... stuff and the subqueries, as a data integrity note - you should verify that the dates being picked up in your between clauses is...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 12, 2009 at 6:20 pm
Just ran into a query here @ SSC that has 36 table joins - asking for tips to improve.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 12, 2009 at 5:54 pm
only4mithunc (11/12/2009)
hi thanks,With table variable it worked..!!!
so shall I conclude that with #table it wont work...?
Regards,
MC
You can make it work with a #table as well. It is trickier,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 12, 2009 at 5:33 pm
Lowell (11/12/2009)
Lynn Pettis (11/12/2009)
Geez, Lowell, you take all the fun out making the OP tell us what the problem is... 😉
mea culpa; it was low hanging fruit and i'm...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 12, 2009 at 5:23 pm
Looks like about the same problem you ran into the other day in this thread.
Here is a blog about the same sort of issue.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 12, 2009 at 5:20 pm
mahesh.vsp (11/12/2009)
Hi,I want to keep track of all the autogrowths of a particular database in sql server table , how can we do that?
This is also along the lines of...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 12, 2009 at 5:11 pm
The best options will depend on your environment. Test the options in your environment.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 12, 2009 at 5:08 pm
Looking at your spreadsheet, it looks like many of the items you see that have excessive fragmentation are actually Heaps. The heap designates that the table is just piled...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 12, 2009 at 5:06 pm
Do you have BLOB data in the table?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 12, 2009 at 5:00 pm
And for grins, just to tidy up a bit
select round(sqrt(sqrt(power(sqrt(avg(isnull(mycolumn,0))),7)))- power(avg(isnull(SumOfpktloanPBO,0)),.62250384),2)
from BLAH
select round(sqrt(power(sqrt(sum(isnull(mycolumn,0))),3)),2)
from BLAH
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 12, 2009 at 4:31 pm
Ok - to 4 decimal places now.
Avg = Sum
Since we deal in pennies, anything after 4 decimal places could be rounded (in theory), and thus Avg could = Sum in...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 12, 2009 at 4:26 pm
Viewing 15 posts - 19,141 through 19,155 (of 19,560 total)