Viewing 15 posts - 13,891 through 13,905 (of 19,560 total)
Atif Sheikh (5/20/2010)
Why dont you write the query as;
Select Sum(CPC)
from campaignclicks
where campaignID = 8
Throw in the isnull and it seems this would work as well.
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
May 20, 2010 at 10:14 am
Paul White NZ (5/20/2010)
Chris Morris-439714 (5/20/2010)
Paul White NZ (5/20/2010)
Chris Morris-439714 (5/20/2010)
Paul White NZ (5/20/2010)
Dynamic SQL - versus - not very dynamic DBAs.Hey Chris, what's with the paint tin avatar?
Paint tin?...
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
May 20, 2010 at 10:12 am
John Rowan (5/20/2010)
sing4you (5/20/2010)
Not pregnant 😀Congrats! I'm happy for you too.
If you don't wish to be then - Congrats.
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
May 20, 2010 at 10:12 am
Swirl80 (5/20/2010)
ISNULL(pe.Col3, pe.Col4) >= @dteFrom
AND ISNULL(pe.Col3, pe.Col4) <= @dteTo
AND ISNULL(pe.Col3, pe.Col4) >= dateadd(mm,-12,getdate())
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
May 20, 2010 at 10:07 am
700 MB is really a small database. 30 MB is tiny for a log file as well.
There really is no reason to shrink this database unless you are...
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
May 20, 2010 at 9:59 am
If all compensation things were equal, then it would come down to hours required to work. If that was equal as well - I would still be doing what...
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
May 20, 2010 at 8:48 am
crookj (5/20/2010)
mbricker-600840 (5/20/2010)
StarkTony
Industries
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
May 20, 2010 at 8:44 am
Chris Morris-439714 (5/20/2010)
sing4you (5/20/2010)
Not pregnant 😀Speak to Barry - he's got his modulus back 😀
SOM
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
May 20, 2010 at 8:41 am
I think I would swap the descriptions between checksum and torn page detection.
reference:
http://msdn.microsoft.com/en-us/library/aa337525.aspx
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
May 19, 2010 at 11:32 pm
dbcc shrinkfile
You can use this command to shrink the individual files (log or data) to a size that suits your needs.
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
May 19, 2010 at 11:27 pm
That depends, do you want to give them access to modify the procs or just execute the procs?
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
May 19, 2010 at 10:00 pm
Test test and test some more. Once you have finished that, test it some more. It is always good to hammer out any errors before releasing it to...
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
May 19, 2010 at 5:55 pm
Not yet but it should be by the end of the year.
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
May 19, 2010 at 4:55 pm
That is a very good reason!!
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
May 19, 2010 at 4:51 pm
It is a natural progression that SQL server uses to improve performance. If you are locking a row for long enough it will escalate into a table lock.
Thus, to...
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
May 19, 2010 at 4:50 pm
Viewing 15 posts - 13,891 through 13,905 (of 19,560 total)