Viewing 15 posts - 3,451 through 3,465 (of 5,841 total)
AShehzad (5/2/2008)
what is difference between stored procedure and user defined functions
There are so many, and they are so situation-specific, that this open-ended question goes WAY beyond what a forum post...
April 22, 2011 at 8:24 am
Grant Fritchey (4/21/2011)
April 22, 2011 at 8:23 am
Steve I really don't understand how you can expect us to help you with so little information given, especially in your first post! Help us help you! 😉
April 22, 2011 at 8:18 am
1) as someone else said, update stats on all tables and try again
2) you may have reached what is known as a "tipping point", wherein the number of rows in...
April 22, 2011 at 8:01 am
For one of the first times I can ever think of I will differ from Grant! I never leave maxdop at 0. On your config (with LOTS of...
April 21, 2011 at 7:38 am
You have TWO sections of "bunches of logic". The question here is if those two sections take much work. If they do, then the cost of a recompile (unless...
April 21, 2011 at 7:33 am
LOOKUP_BI-756009 (4/20/2011)
Kevin, thank you so much. It works great. I've learnt something new today thanks to you.
Glad to help!
April 20, 2011 at 7:48 pm
Joy Smith San (4/20/2011)
What do you suggest to pull data from DB's in other servers then.?
I have had great success at clients using replication to help avoid cross-server data access...
April 20, 2011 at 8:39 am
VERY impressive splitter improvements there Jeff! Well done!!
April 20, 2011 at 8:13 am
There is an alternative - 2 of them actually. The first is to not do this kind of multi-datatype-column design. 😎
The other is to use my favorite 4 letter...
April 20, 2011 at 7:56 am
If you need to stay online while this is going on, you must batch the updates into smaller groups of say 1000 to 5000 records at a time using an...
April 20, 2011 at 7:39 am
1) Your best bet BY FAR is to have a qualified professional remote into your machine and debug the perf issue. Probably take under an hour for said individual...
April 20, 2011 at 7:37 am
Tara-1044200 (4/18/2011)
would there be any performance difference have a link server between 2 sql server using server type as Other data source("Microsoft OLEDB for SQL Server") versus SQL Server.
I would...
April 20, 2011 at 7:33 am
lianvh (4/19/2011)
The server is running on a SAN with 15kdisks. The Log and MData files are on seperate LUNS.
That answer leaves umpteen things unanswered. You statement could be this:...
April 19, 2011 at 10:56 am
Nothing personal here but you have made design and indexing choices that tell me that you have absolutely no hope of successfully interacting with a 14B row FAT table. ...
April 19, 2011 at 6:46 am
Viewing 15 posts - 3,451 through 3,465 (of 5,841 total)