Viewing 15 posts - 2,011 through 2,025 (of 2,647 total)
Thanks for that, but what I am really trying to get at in this post is not an actual delimited string,...
January 4, 2012 at 10:22 am
Ninja's_RGR'us (1/3/2012)
GilaMonster (1/3/2012)
Ninja's_RGR'us (1/3/2012)
Yes, read the book!She's not lazy, it's not something she can answer in 2 words.
Just to put things in perspective, the chapter that I'm referring you to...
January 3, 2012 at 9:56 am
Jeff Moden (12/23/2011)
SQLKnowItAll (12/22/2011)
December 24, 2011 at 5:41 am
krowley (12/23/2011)
Let's rephrase the question, if I were planning to hire a DBA etc... What salary range should I be planning to budget for.
Well... Where is the job? Chicago would...
December 23, 2011 at 10:22 am
there are a lot of popular data warehousing techniques that are plain wrong.
This is a very dangerous statement. There are very few things in our area that are "just...
December 23, 2011 at 7:27 am
Dev (12/23/2011)
In my case I also have 2 post-graduate degrees, one of which pertains managing a business and understanding these types of things. Like a techy MBA :)...
December 23, 2011 at 6:16 am
Jeff Moden (12/22/2011)
Ninja's_RGR'us (12/22/2011)
Jeff Moden (12/21/2011)
Aspet Golestanian Namagerdi (12/21/2011)
December 23, 2011 at 6:06 am
GilaMonster (12/23/2011)
dilipd006 (12/23/2011)
I decided to go for seperate tables, as it would be easy to maintain.
Easier to maintain maybe, probably easier to query, likely better performance and far less chance...
December 23, 2011 at 6:03 am
GSquared (12/22/2011)
David Moutray (12/22/2011)
GSquared (12/22/2011)
And I dropped out of both kindergarden and college! But I've got a well-paid DBA job anyway.
Heh. I'm glad I'm not the only one!...
December 22, 2011 at 5:01 pm
I like how you say this is random slowness, when in fact it is every 10 minutes 🙂 Is it possible for you to run a server-side trace to see...
December 22, 2011 at 10:59 am
I would store the common information for the products in 1 table. Almost like a header table. Then store the details for a specific product in their own tables. For...
December 22, 2011 at 10:50 am
David Moutray (12/22/2011)
MysteryJimbo (12/21/2011)Generally I've found DBA's get paid around 15-20% more than developers in the same company and around the same as Development management.
Does it seem wrong to anyone...
December 22, 2011 at 10:41 am
VIG (12/21/2011)
results of running Jeff Moden's script on my 2008R2 with additional cast/cast convertion
(1000000 row(s) affected)
--===== DATEADD/DATEDIFF =============================================
SQL Server Execution Times:
...
December 21, 2011 at 5:28 am
Well then, it was not an article, but your test. Thanks for posting again! Would you mind if I mentioned this test in my blog and cited you for...
December 20, 2011 at 8:33 pm
Faster:
SELECT CAST(DATEDIFF(d,0,GETDATE()) AS DATETIME)
Can't find the article offhand that proves this, but I will continue to look. Could it be one of Jeff's?
December 20, 2011 at 3:00 pm
Viewing 15 posts - 2,011 through 2,025 (of 2,647 total)