Viewing 15 posts - 54,796 through 54,810 (of 59,098 total)
Won't work with 2005's encryption routines. They're non-deterministic. Encrypt and compare will get you no matches.
Didn't know that. Wow... the boy's in Redmond pretty much blew it there...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 1, 2007 at 8:41 pm
really old server, 512MB ram and 2 300Mhz processors (yes that's an M not a G)
I'm thinking that you've squeezed just about all the speed you're gonna get out of...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 1, 2007 at 8:33 pm
Bob Fazio (10/1/2007)
Formatting in this new site is less than adequate.
I absolutely agree!
Insert of 3.3m rows.
Best run (no index). 270 - seconds
worst run (with index) 283...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 1, 2007 at 8:21 pm
Kurt W. Zimmerman (10/1/2007)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 1, 2007 at 7:01 pm
... and what about the EndDates that are NULL? 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
October 1, 2007 at 6:38 pm
Post the entire test harness so we can do the same test, Tom 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
October 1, 2007 at 6:33 pm
Oh... and do be aware that STR uses FLOAT for it's main operand... 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
September 30, 2007 at 9:46 am
Ninja's_RGR'us (9/29/2007)
So Jeff, how do you solve this version of the problem?Set @i = 0.034
PRINT REPLACE(@i,'.','')
--003400 OR 34?
Set @i = 0.0304
PRINT REPLACE(@i,'.','')
--003040 OR 304?
I assume you're talking about adding leading...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 30, 2007 at 9:45 am
nigelrivett (9/29/2007)
If you want to report on full history of the data...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 30, 2007 at 9:09 am
Ninja's_RGR'us (9/29/2007)
2 what do you do about the rule that says that auditing data should...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 30, 2007 at 8:40 am
Outstanding job Steve, Warren, and Andy!!! Yeah, I know... Warren and Andy are on the "sidelines" now, but that group of 3 started this! Nicely done!
--Jeff Moden
Change is inevitable... Change for the better is not.
September 30, 2007 at 8:19 am
Open Query Analyzer...
Press f8...
Drill down to table and "columns"...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 30, 2007 at 8:09 am
I think you might need two roles... one for WebGroup and one for WebGroupAdmin which is where you'd put Tracey. Then maybe do some correct grants?
--Jeff Moden
Change is inevitable... Change for the better is not.
September 30, 2007 at 8:03 am
Simply put, there are more reasons than I could possibly post here as to why you should not, nay, must not store dates as 3 separate columns. The efficiency...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 29, 2007 at 11:24 pm
I gotta ask, because you're a newbie....
Why are you worried about reassigning barcodes? Bar codes can be made to easily exceed 2 billion (approximate max for an INT). ...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 29, 2007 at 11:13 pm
Viewing 15 posts - 54,796 through 54,810 (of 59,098 total)