Viewing 15 posts - 17,536 through 17,550 (of 22,226 total)
If your users just need to read data then maybe all you need are some reports written through SQL Server Reporting Services. These can be fed through the web and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 6, 2009 at 7:45 am
It really depends on the business requirements. But if you're dealing with hard numbers, I'd use decimal instead of float. Float is an approximate number. This is from the BOL:
Approximate-number...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 6, 2009 at 7:41 am
pushpa.kumari (5/6/2009)
Hi,text datatype can have maximum length of 8000.
I think you should break your dynamic query into 2-3 parts.
Text doesn't actually have a limit that low. Large Objects, LOB...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 6, 2009 at 7:11 am
I agree with the use of the information_schema instead of the system tables. There've been quite a few changes in how those system tables behave, what you can, etc., between...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 6, 2009 at 7:08 am
Dugi (5/6/2009)
Grant Fritchey (5/6/2009)
You can call it from the command line. If you had to do it through TSQL, you could use xp_cmdshell, but I wouldn't recommend it.
Yep, my friend...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 6, 2009 at 7:06 am
You can call it from the command line. If you had to do it through TSQL, you could use xp_cmdshell, but I wouldn't recommend it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 6, 2009 at 5:40 am
Yeah, I was wondering the same thing. Can you post the two execution plans, the good one and the bad one?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 5, 2009 at 3:33 pm
Ah, I didn't know about the linked server before. Not that it gives me an idea what the problem is, but it does toss another wrinkle into the issue.
For those...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 5, 2009 at 1:21 pm
RBarryYoung (5/5/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 5, 2009 at 11:58 am
RBarryYoung (5/5/2009)
Alvin Ramard (5/5/2009)
David Burrows (5/5/2009)
Then you have those that would bite the hand that is trying to feed them.
Lucky for the OP that is was not Jeff, Pork Chops...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 5, 2009 at 9:16 am
You're way too nice Lynn. I would've walked away. If I need people yelling at me when I'm trying to help, I can go home & help the kids with...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 5, 2009 at 6:58 am
Luke L (5/5/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 5, 2009 at 6:53 am
Just a question, why have the governor in place at all if you're going to remove the limits as soon as you hit them?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 5, 2009 at 6:48 am
To know what the DTA looks for inside it's code, you need to talk to someone at Microsoft. There's very little in the documentation (available here, just so you have...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 5, 2009 at 6:33 am
I'm a film school drop out. No degree, at all.
However, to get past the HR check boxes, I do list the school I attended. I just don't list a degree....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 5, 2009 at 6:10 am
Viewing 15 posts - 17,536 through 17,550 (of 22,226 total)