Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,651 through 43,665 (of 59,063 total)

RE: To write a query

Florian Reischl (5/24/2009)
Jeff Moden (5/23/2009)
Florian Reischl (5/23/2009)
Maybe it's time for your 5 bugs 😀
Ok... I'll bite. What do you mean here? I blame it on failing memory and...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 24, 2009 at 11:02 am

#999471
RE: The Real SQL Server Experts

ta.bu.shi.da.yu (5/24/2009)
Absolutely! I'm just saying that I think that open source projects are more influencable or are quicker to implement changes than closed source companies. My $0.02.
You and I both...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 24, 2009 at 10:57 am

#999469
RE: Introduction to Bitmasking in SQL Server, Part 2

marshall.jones (5/23/2009)
That would be the case if I was actually doing what's happening in that example.
In practice other constraints on the datasets ensure that the number of reads is in...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 24, 2009 at 12:24 am

#999421
RE: SQL 2008 - DBA

dbpatel.2784 (5/22/2009)
Thanks for the interest but i think i got the resolution. Thanks for helping ...
Heh... I'm thinking "Check Valve" right now.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 23, 2009 at 10:11 pm

#999416
RE: Original Theatrical Release of Star Wars

Lynn Pettis (5/23/2009)
David Burrows (5/23/2009)
but she who must be obeyed would have fit.
It's easier to ask for forgiveness than it is for permission. :w00t:
Would not matter, if she isn't happy,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 23, 2009 at 10:03 pm

#999415
RE: The Real SQL Server Experts

ta.bu.shi.da.yu (5/23/2009)
Well, bare in mind I'm talking about organized projects, not little snippets of code. Look at the Samba project - they're about to get to the point where you...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 23, 2009 at 10:01 pm

#999414
RE: Parse multiple dates from Text Field

The TEXT column in question is that of a "log" maintained by humans. Likely as not, it has some hidden delimiters in it. Please check the data for...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 23, 2009 at 9:52 pm

#999413
RE: Need help in update query

v.bragadeesh (5/23/2009)
Thanks all, its working
Bragadeesh
Heh... What is working? Please post your final code.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 23, 2009 at 9:40 pm

#999411
RE: The Real SQL Server Experts

Heh... Open Source... Yep, I've seen what happens there. Just look at what some people write CLR's for. Some of it is good. Most of it is...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 23, 2009 at 9:34 pm

#999410
RE: Dataload using Powershell - 15+GB /day

I agree with Flo. Bulk Insert will load 5.1 million rows of data 20 columns wide in less than 60 seconds.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 23, 2009 at 9:30 pm

#999409
RE: T-sql procedure error in job

Sergiy (5/22/2009)
J (5/22/2009)
I am new to SS2K5. would you please explain in greater detail WHY ?
Because "T" in T-SQL means "transactional".
Because while you try you may affect the data used...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 23, 2009 at 8:58 pm

#999407
RE: Do You Have a Problem?

bob.willsie (5/21/2009)
Is there a certification for DBAs?
If so, is the testing process kept up to date? (Years ago I almost went for CDPM certification until I found out half...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 23, 2009 at 8:50 pm

#999406
RE: Query Help

Thanks for the feedback, Allister.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 23, 2009 at 8:33 pm

#999405
RE: Copying a SQL 2005 database

Most flavors of a SAN come with "snapshot" capabilites that solve these types of problems.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 23, 2009 at 8:24 pm

#999404
RE: Are the posted questions getting worse?

GilaMonster (5/23/2009)
<sigh>
"I detached the DB, deleted the log file and it won't attach. Backups not working either"
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=126304
Head-desk
Why???????????
Ah, ah! There you go again... 😛 No wonder you get the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 23, 2009 at 8:04 pm

#999403

Viewing 15 posts - 43,651 through 43,665 (of 59,063 total)