Viewing 15 posts - 4,591 through 4,605 (of 9,715 total)
GilaMonster (3/27/2012)
Is it just me, or does a term like 'That can be done, but people usually learn better' rankle when applied to something you've said?Feels a little condescending.
That...
March 27, 2012 at 7:26 am
There is no script for determining dynamic SQL. You need to ask the developer if he is using it in the system.
If he is, then that will explain some...
March 27, 2012 at 6:31 am
ananda.murugesan (3/27/2012)
Brandie Tarvin (3/27/2012)
How much dynamic SQL do you use in your environment, ananda?
Thanks for reply..
Total 4GB RAM, 32 bit system, os - win 2008 enterprise edition,
SQL - SQL server...
March 27, 2012 at 5:26 am
Okay, folks. For those who are interested in our play project, the Universal ID Project thread can be found here:
http://www.sqlservercentral.com/Forums/Topic1273368-61-1.aspx?Update=1
March 27, 2012 at 4:43 am
How much dynamic SQL do you use in your environment, ananda?
March 27, 2012 at 4:24 am
Evil Kraig F (3/26/2012)
Brandie Tarvin (3/26/2012)
How would you all like to design the system (and database) around this one: http://www.cnn.com/2012/03/26/opinion/frum-identity-cards/index.html?hpt=hp_bn7Sold. Can we start the tech spec tomorrow?
I think it...
March 26, 2012 at 5:08 pm
How would you all like to design the system (and database) around this one: http://www.cnn.com/2012/03/26/opinion/frum-identity-cards/index.html?hpt=hp_bn7
March 26, 2012 at 4:55 pm
Kiara (3/26/2012)
Happy Monday, folks!Just coming up for air after a couple of weeks of crazy. Figured I'd catch up on The Thread and say "Hi".
Hi, back. Welcome to this week's...
March 26, 2012 at 4:40 pm
Evil Kraig F (3/26/2012)
March 26, 2012 at 2:04 pm
george sibbald (3/26/2012)
so if I read it right a preponderance of ad hoc SQL but they are getting some re-use?
Not really. That last column tells me that the number...
March 26, 2012 at 1:46 pm
opc.three (3/26/2012)
Brandie Tarvin (3/26/2012)
opc.three (3/26/2012)
Cool, thanks for posting back....
I would explore enabling the adhoc workloads server configuration if it's not already on.
Opc, you do realize I'm not the OP, right?...
March 26, 2012 at 12:19 pm
opc.three (3/26/2012)
Cool, thanks for posting back....
I would explore enabling the adhoc workloads server configuration if it's not already on.
Opc, you do realize I'm not the OP, right? I only posted...
March 26, 2012 at 12:11 pm
I don't have Kimberly's contact information to email her the updated proc.
As far as my results go, they're pretty nasty.
CacheType Total Plans Total MBs Avg Use Count Total MBs...
March 26, 2012 at 11:52 am
If you run into the overflow error, like I did, try this:
SELECT objtype AS [CacheType],
COUNT_BIG(*) AS [Total Plans],
...
March 26, 2012 at 11:28 am
Viewing 15 posts - 4,591 through 4,605 (of 9,715 total)