Viewing 15 posts - 1 through 15 (of 17 total)
You seem pretty sure. Have you tested it?
Tested / Worked with = Yes
January 2, 2009 at 10:06 pm
Wow...
Two things
1) Never use Cursors! Looping through a temp table takes less overhead than a Cursor; especially when you are working on a 24/7/365 server where you really need...
January 1, 2009 at 8:39 pm
Also, when you say "Imagine scaling the cursor to tables with millions of rows". I'm imagining it! Are you sure that inserting the rows into a temporary table with no...
January 1, 2009 at 8:38 pm
Lavish paychecks?! Man am I in the wrong company...
I think what makes a good programer is someone who is always willing to learn new processes and new technology. I'm a...
July 9, 2007 at 3:16 pm
On the flip side, it will make the users more aware of the implications of hosing their laptops.
To most users that have a laptop given to them by my...
December 15, 2006 at 7:27 am
I have been rebuilding our HR database and I need a way to keep legacy information (i.e. Staff, Office Locations, etc...). I decided that a trigger was the best way...
August 18, 2006 at 7:24 am
Not only do I do database development but I also code applications as well. I usualy throw on a datatype for a quick mental reference when coding and also I...
August 4, 2006 at 8:48 am
I do use "_" in stored procedure names but I prefice the name with the database (I know another abvr coming up).
So my Stored Procedure for pulling information from the...
August 4, 2006 at 8:43 am
I don't have the time to read 101 posts and I'm sure someone else has mentioned some of the things I'm going to say.
I don't agree with the naming convention...
August 4, 2006 at 7:47 am
For those of you who do not understand the dog reference (I’m not going to read 58 posts to see if some one else explained it) it is an...
October 17, 2005 at 2:10 pm
She wasn't canned for her beliefs; she was canned for putting her beliefs into company reports.
What if the reports were for Muslims, Jewish people, or atheist?
If...
October 17, 2005 at 1:55 pm
I normally don't post that often (being a one man show at work I don't always have time to read SqlServerCentral.com everyday, let alone post), but I think I need...
July 27, 2005 at 8:13 am
A variation of Sam's:
SELECT TOP 100 PERCENT [rowid]
FROM [tableA]
WHERE [rowid] NOT IN (
SELECT TOP 100 PERCENT [rowid]
FROM [tableB]
)
ORDER BY [rowid]
July 26, 2005 at 7:58 am
Here is where I am at with PK, FK and AK (Alternate Keys / Indexes), every table needs a PK, period. I don't care how small the table is or...
July 22, 2005 at 10:28 am
Viewing 15 posts - 1 through 15 (of 17 total)