Viewing 15 posts - 3,556 through 3,570 (of 15,381 total)
Damian-167372 (11/21/2014)
is there a way we can do this in WHILE Loop?
Sure...you could replace the cursor with a while loop. However, all you are going to do is make it...
November 21, 2014 at 8:02 am
andrew gothard (11/21/2014)
Bar in my home town.Can't see it being suitable for a gathering, somehow. Certainly if Jeff Moden's invited,
LOL here is the mug from a bar near...
November 21, 2014 at 7:58 am
Damian-167372 (11/21/2014)
this query will just go into a stored procedure only, no functions or any other method.
Here is the challenge. You obfuscated the real meat of what is going on....
November 21, 2014 at 7:50 am
Great question but the explanation and the linked article were terribly disappointing. The article says to use the table designer for creating indexes after it explains what a table is...
November 21, 2014 at 7:19 am
gordon.feeney (11/21/2014)
I have to say I thought all the queries would use the non-clustered scan as it was just as quick to do a scan than a seek.
That was my...
November 21, 2014 at 7:16 am
SpeedSkaterFan (11/20/2014)
Thx for your reply
The fields I did mention in my question are the fields that will be used most in queries.
Sometimes all fields will be necessary, sometimes only...
November 20, 2014 at 1:45 pm
SpeedSkaterFan (11/20/2014)
I have read quite a bit about adding an index to a table, and understand the importance. I think I get the general idea, but I am confused...
November 20, 2014 at 1:15 pm
Koen Verbeeck (11/20/2014)
Sean Lange (11/20/2014)
November 20, 2014 at 7:38 am
serg-52 (11/20/2014)
You posted code that contained a function ufn_Tally2 but you didn't post it. Do you really have a function that creates a tally table on the fly? Seems like...
November 20, 2014 at 7:34 am
Koen Verbeeck (11/20/2014)
Toreador (11/20/2014)
GROUPING_ID was introduced in SQL2008. The others were all available in SQL2005.And VARP is the only function with a name less than 5 characters! :w00t: 😎 :hehe:
But...
November 20, 2014 at 7:27 am
Koen Verbeeck (11/20/2014)
This means people have to vote for me (or other people, but preferable me):
http://www.mssqltips.com/MSSQLTipsAuthorVoting.asp
Note that you...
November 20, 2014 at 7:17 am
notifications 61467 (11/19/2014)
Thanks for your reply.
I located a suggestion for the problem I was experiencing:
I substituted a local variable for the stored procedure parameter used in multiple where clauses.
The SP...
November 19, 2014 at 4:25 pm
Jeff Moden (11/19/2014)
November 19, 2014 at 4:07 pm
DSNOSPAM (11/19/2014)
November 19, 2014 at 3:26 pm
Luis Cazares (11/19/2014)
Matt Miller (#4) (11/19/2014)
Sean Lange (11/19/2014)
DSNOSPAM (11/19/2014)
I've been reading about possible performance hits. However, this is in a reporting/analysis environment, not on a production server, and...
November 19, 2014 at 3:03 pm
Viewing 15 posts - 3,556 through 3,570 (of 15,381 total)