Viewing 15 posts - 20,446 through 20,460 (of 22,197 total)
That depends. It could be that it's returned to an application as a result set and then run as a script by the app. It could be that it gets...
May 7, 2008 at 6:06 am
We pretty much rely on the application side checks after a successful restore. As you point out, restoring successfully doesn't mean you restored the right thing successfully. DBCC and other...
May 7, 2008 at 6:03 am
No, no, no. Jeff's smarter and better looking. I'm.... uh, I'm.... Hey!
May 7, 2008 at 5:57 am
I've been staying out of this one, but I have to agree with Jeff. The more you practice writing set based queries the easier they get. Add to that the...
May 7, 2008 at 5:52 am
Don't substitute table variables for temp tables unless your data sets are very small. Table variables don't have statistics generated against them (except when they have a primary key and...
May 7, 2008 at 5:47 am
I'll have you know I'm down to 203 and at 6'1" that's not big, just a tad plump. It's sitting on my brain all day long that causes the problems....
May 6, 2008 at 1:25 pm
Everything already stated is very true. Code, tables and indexes are going to be your worst problems. However, you can be sure that you've identified the really simple stuff if...
May 6, 2008 at 12:34 pm
I should be too embarassed to reply, but what the heck...
Scans are usually bad, but not always. Depending on the scan itself, it means it's reading all, or a substantial...
May 6, 2008 at 12:29 pm
You said above that you ran the code against CustomerId and it worked. I'll bet CustomerId is an integer column.
May 6, 2008 at 7:57 am
And what level of access does that user have? Is the server set up with 'sa' and no password?
Yes, setting up procs is work, but your core issue is...
May 6, 2008 at 7:00 am
It's not an alias you're looking for but some formatting. Try changing to this:
CAST(SizeInGigs=floor( backup_size/1024000000) AS VARCHAR) + ' GB'
An alias is a way of masking or changing a...
May 6, 2008 at 6:26 am
The only thing I can think of would be to lower the cost threshold for parallelism. But then you're likely to see multiple threads in queries that will not benefit...
May 6, 2008 at 6:23 am
onlybemine (5/6/2008)
Its ASP Website & i am hardly using stored proceduer....Its old done websit with classic ways of Inline Coding..........
I nornally wouldn't pile on to something like this with a...
May 6, 2008 at 6:17 am
What about trying it like this:
select * from customertable where customercode = '01042'
If customercode is a string, you need to wrap the number being passed so that it's a string...
May 6, 2008 at 6:14 am
I didn't read through everything, but you are issuing DDL commands within your procedure which will cause recompiles of the procedure while it executes. That may not be the cause,...
May 6, 2008 at 5:59 am
Viewing 15 posts - 20,446 through 20,460 (of 22,197 total)