Viewing 15 posts - 46,096 through 46,110 (of 59,062 total)
We use a ticketing system to both assign problems and track code. Ticket number in the file name or a folder name works wonders. Each object is stored...
January 3, 2009 at 9:17 pm
And, seriously... if you want better answers faster and maybe even tested answers, post the data for future requests using the techniques found in the link in my signature below.
January 3, 2009 at 9:02 pm
Just to be absolutely correct... the DATEADD portion of the code should be the following...
DATEADD(DD, 1, @specific_day)
January 3, 2009 at 8:54 pm
Now that you have several different methods for separating the data, my recommendation would be to normalize the table so you don't have to use any of those methods in...
January 3, 2009 at 8:51 pm
With the information given, the short answer would be to take a look at ROW_NUMBER OVER (PARTITION BY... ORDER BY...) in Books Online. You could also do similar with...
January 3, 2009 at 8:49 pm
hfxDBA (12/24/2008)
January 3, 2009 at 8:22 pm
battelofhalfwits (1/2/2009)
You seem pretty sure. Have you tested it?
Tested / Worked with = Yes
After all of that, you've just gotta know what's coming...
... prove it. 😉
January 3, 2009 at 8:09 pm
Gaby A. (12/23/2008)
Comments posted to this topic are about the item
Heh... "Cursors Be Gone", indeed... see what you started? 😉 But, do try to pick a better...
January 3, 2009 at 7:59 pm
Haroon Said (12/24/2008)
January 3, 2009 at 7:56 pm
My poor ol' (but very reliable) desktop has a single 1.8 Ghz P4... it's not even a P5. But, like I said earlier, when I get something to run...
January 3, 2009 at 7:45 pm
Matt Whitfield (1/3/2009)
Jeff Moden (1/3/2009)
Nope... unless you changed it for your server, the default Fill Factor is 90.
Are you sure? On all the servers i've found, i get this result...
January 3, 2009 at 5:25 pm
Matt Whitfield (1/3/2009)
@jacroberts - can you include that last one in your test runs monday? I know it's cheating, but I...
January 3, 2009 at 5:04 pm
Matt Whitfield (1/3/2009)
You are intensely cool. 1.796. And I'll agree with what was said above - i am most impressed by the way you got the data out of that...
January 3, 2009 at 4:54 pm
Matt Whitfield (1/3/2009)
Phil Factor (1/3/2009)
The other thing I missed was the WITH FILLFACTOR = 100. Neat!
Erm... I think i'm missing something. Isn't 100 the default fillfactor for any...
January 3, 2009 at 4:47 pm
Nope... I'm right there with you on some of the pig databases, especially considering the "time elements", we've both seen in this world.
And yes, I absolutely agree... there's a...
January 3, 2009 at 4:36 pm
Viewing 15 posts - 46,096 through 46,110 (of 59,062 total)