Viewing 15 posts - 50,461 through 50,475 (of 59,078 total)
Now... I DO have a question! Did I have to do all of that? I mean the part about making an exception in the XP firewall and all?...
May 17, 2008 at 7:56 pm
Heh... LMAO!!! That's funny... RBARry Young... hadn't thought of that. :hehe:
May 17, 2008 at 7:44 pm
rbarryyoung (5/17/2008)
Jeff, couldn't you use MAX(CAST(RestrictedID as int)) instead of SUM(SIGN(..))?
Absolutely... just didn't want to type that much 😛
Karthik, no function is required. The function is inherently RBAR in...
May 17, 2008 at 7:40 pm
It appears that I've got it... found the wonder "connection window" that allowed me to select the connection instead of typing the bloody connection information. The tutorial says to...
May 17, 2008 at 7:30 pm
I found this on Google:
I did the whole thing including the Firewall exceptions for MSSQL.1... I notice that I also have an MSSQL.2 and MSSQL.3... do I have to do...
May 17, 2008 at 7:07 pm
Shrinking database files that grow everyday is a futile thing to do to try to save space and fragments the heck out of the files on the OS.
Disk space is...
May 17, 2008 at 1:07 pm
... like this...
SELECT d.*
INTO new_table_name
FROM (--=== Michael's subquery with a slight mod
select min(RecordId)
...
May 17, 2008 at 1:03 pm
george sibbald (5/17/2008)
Just to re-cap Jeff, you reckon best option to use Michaels subquery to select out to a new table, and will be faster than the delete? That...
May 17, 2008 at 12:57 pm
Wonderful job, Brandie... it's great! You should have submitted this as an article! 🙂
May 17, 2008 at 12:51 pm
There are many people that don't really understand how recursion works, and with it's new possibilities with CTEs, I'd really encourage all DBAs to add this tool to their list...
May 17, 2008 at 9:36 am
So have the job update a single row in a log table and make the code check it at the beginning... for example, if the last entry was more than...
May 17, 2008 at 9:25 am
Wilfred van Dijk (5/17/2008)
wait till MSSQL2008 🙂(don't get angry on me, I think a lot of people had the same question)
Heh... I, on the other hand, will loath the day...
May 17, 2008 at 9:19 am
Oh yeah... almost forgot... Like you said, George, it will likely be cheaper to insert good rows into a new table because you won't have indexes and the like to...
May 17, 2008 at 9:17 am
The problem is that both pieces of code will work very fast when there's only a couple thousand dupes and that's the the case here... George said that there's 6.3...
May 17, 2008 at 9:15 am
Why do you need to do this? It may make a difference...
May 17, 2008 at 1:09 am
Viewing 15 posts - 50,461 through 50,475 (of 59,078 total)