Viewing 15 posts - 57,931 through 57,945 (of 59,066 total)
Seqiy,
Do you have a Microsoft URL for "And prefixing tables with "tbl" as well as all other objects in SQL decreases database performance. Just in case you did not hear...
July 31, 2006 at 12:23 pm
Shyam,
Although Serqiy has gotten blunt as all get-out, he's absolutely correct. Why on earth would you want to modify the content of the IDENTITY column? If you run out of...
July 31, 2006 at 12:18 pm
Unless you haven't posted all of the code, you, in fact, as the SQL Junkie suggested, do not need a cursor for this. Did you try the SQL Junkie's code? ...
July 31, 2006 at 12:07 pm
A little off-the-wall but I've run into similar problems with other things... the way I got around it was to run this type of thing on each server with an...
July 31, 2006 at 11:58 am
Actually, if your users are experienced in MS-Access, what's wrong with them using it? The only other thing you could do is either write you own Web app to do...
July 31, 2006 at 11:49 am
Thank you for the feedback. If you add tabs instead of commas, it'll open up in Excel without much of a conversion at all. Didn't realize that the target of...
July 31, 2006 at 11:40 am
So, what your telling me is that @facturas_id2 is a VARCHAR like it needs to be? Make sure because I didn't see it defined in any of the code you...
July 28, 2006 at 5:53 pm
You'll take one look at this and think I'm as crazy as a cyclist on steroids... but try it... no real loop, nasty fast, and does not require a function...
July 28, 2006 at 5:42 pm
My 2 cents...
SELECT DATEADD(mi,30*Number,0) AS BW1
INTO #v_hcdata_Total
FROM MASTER.dbo.spt_Values
WHERE NAME IS NULL
AND Number < 48
July 28, 2006 at 4:38 pm
Certification will require some tenacity on your part...
Anyway, take a look at this url...
http://www.microsoft.com/learning/mcp/sixsteps.asp
July 28, 2006 at 6:48 am
How true, how true... I'm still waiting for Ravi to post some code and maybe give us a hint as to the rowcounts in the tables.
Ravi, while were waiting,...
July 28, 2006 at 6:36 am
Warning... most of those sub-queries contain inequality comparsisons that form triangular joins... I haven't looked super close at them but triangular joins normally mean "Death By SQL" on larger record...
July 27, 2006 at 8:34 pm
If it were me, I'd search the Microsoft website for "certification" to get the info straight from the horse's mouth.
July 27, 2006 at 8:29 pm
It may also be that the Customer table is actually some (synonym) view that someone changed or changed the underlying table on. My recommendation is to do an execution plan...
July 27, 2006 at 8:24 pm
The query does not make it's own deadlocks... the query is not wrong. Take a look at Books Online... something else is wrong... it may be that someone added a...
July 27, 2006 at 8:14 pm
Viewing 15 posts - 57,931 through 57,945 (of 59,066 total)