Viewing 15 posts - 496 through 510 (of 965 total)
Run DBCC UPDATEUSAGE on the database and check the free space for the database again.
February 5, 2009 at 6:41 am
Phil Factor (2/5/2009)
I can see why a...
February 5, 2009 at 2:20 am
Carleton (2/5/2009)
Thanks Jonathan for this very timely article! Can you advise whether this CLR function will work for UNC paths?Thanks,
Carleton
As long as the SQL Service Account has access to...
February 5, 2009 at 2:18 am
NotManyPoints (2/4/2009)
the only knowledge I have about SQLCLR is that it is there.
'awareness'
The OP asked about SQL Injection.
'awareness'
What's your arguement?
February 4, 2009 at 12:08 pm
DavidB (2/4/2009)
Lynn Pettis (2/4/2009)
February 4, 2009 at 12:05 pm
rsteeves (2/4/2009)
This table has 19.8GB of used space. I tried the Alter Index All on hstordersummary REBUILD and it did not free up the unused space.
When...
February 4, 2009 at 8:55 am
Yes, Parameters allow for plan reuse by the plan cache.
February 4, 2009 at 6:48 am
Lynn Pettis (2/3/2009)
So, we are back to having to know something about all aspects of SQL Server again....I'm sorry but you can't have your cake and eat it too...
Exactly. ...
February 3, 2009 at 8:16 pm
Gunjan (2/3/2009)
Thanks Jonathan.I am going to use the WCF for printing the image. I will use it in my SQL CLR stored proc.
Thank you all for the help.
I don't think...
February 3, 2009 at 7:54 pm
RBarryYoung (2/3/2009)
Jonathan: which is the part that cannot be done? Just the Bitmap stuff or do you mean anything from System.Drawing.dll?
According to the following blog:
http://blogs.msdn.com/tims/archive/2004/05/27/142798.aspx
System.Drawing is not allowed...
February 3, 2009 at 4:34 pm
doobya (2/3/2009)
Jonathan Kehayias (2/3/2009)
Take a look at the article from yesterdy. A missing/incorrect index can most definitely be the cause of a deadlock. In fact most deadlocks are...
February 3, 2009 at 4:18 pm
amiller (2/3/2009)
🙂 Very interesting and with many information I didn't know. One more, does the ALLOW_PAGE_LOCKS option on indexes in the tables involved matters for deadlocks?thanks
Albert
Albert,
YES. These options make...
February 3, 2009 at 4:15 pm
Thanks Gail. Working from my Palm Treo at the moment and missed that word. Tiny keyboard and fat thumbs never works out that good.
February 3, 2009 at 1:46 pm
I am not in a position to check immediately but I would venture a guess that the HPA's on the Assembly may preclude it from use in SQL completely. ...
February 3, 2009 at 1:05 pm
You are the 3rd person to try this, and it is not possible to do. This is akin to trying to use a MessageBox.Show() in a clr routine in...
February 3, 2009 at 12:33 pm
Viewing 15 posts - 496 through 510 (of 965 total)