Viewing 15 posts - 4,306 through 4,320 (of 14,953 total)
Jim Murphy (5/10/2011)
Brandie Tarvin (5/10/2011)
Jim Murphy (5/10/2011)
Brandie Tarvin (5/10/2011)
May 10, 2011 at 12:16 pm
GilaMonster (5/10/2011)
GSquared (5/10/2011)
May 10, 2011 at 12:14 pm
Yes, you can prevent locks in the UDFs by making sure all of your connections are set to Transaction Isolation Level Read Uncommitted.
That will remove all of the select locks....
May 10, 2011 at 11:58 am
Keep in mind that this method will give false results if product codes can contain other product codes as a substring.
If, for example, you have a product code "A100" and...
May 10, 2011 at 11:51 am
Should the application have direct table access, or does it do everything via stored procedures?
May 10, 2011 at 11:27 am
Have you tried connecting Excel to SQL Server? I've done that, for pivot tables, et al, and it works beautifully.
As for SSRS, Report Builder has wizards for building reports...
May 10, 2011 at 11:25 am
Start with sp_trace_create. Check that on MSDN, and it'll refer you to sp_trace_setevent, fn_trace_getinfo, and all the rest.
May 10, 2011 at 11:20 am
Gail, sent four devs to your Catch-All Queries blog entry today. Thanks again for writing that. They all got it and one even got excited about it. ...
May 10, 2011 at 11:19 am
Brandie Tarvin (5/10/2011)
May 10, 2011 at 10:45 am
You'll end up with compile locks for a number of reasons. The most common is if you don't use two-part names for objects being accessed by the UDFs. ...
May 10, 2011 at 10:36 am
jcrawf02 (5/10/2011)
Jim Murphy (5/9/2011)
GSquared (5/9/2011)
I work in Orlando and live a few miles outside it
Ah yes. I do see something in your profile about Orlando. So you probably know a...
May 10, 2011 at 9:26 am
Cloud computing is just re-centralization, with all the advantages and disadvantages of that.
As already mentioned, it's like electricity. You can have your own power plant (there's motion in that...
May 10, 2011 at 7:31 am
There may be a few minor performance-tuning differences between 2005 and 2008, but the vast majority of the data will be applicable to both. The differences between the two...
May 10, 2011 at 7:02 am
WayneS (5/10/2011)
GSquared (5/9/2011)
I just registered for the PASS Rally in Orlando.See you there, somewhere!
The amusing part is that I work for a company that markets Orlando as a destination. ...
May 10, 2011 at 6:57 am
I'm a little late on this one (didn't know about the question till I saw a link from The Thread). If you suffer from post-presentation insomnia or other stress...
May 10, 2011 at 6:51 am
Viewing 15 posts - 4,306 through 4,320 (of 14,953 total)