Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,051 through 43,065 (of 59,098 total)

RE: Split string using XML

Eralper (7/10/2009)
Actually, I made a simple test to see that the xml function is quicker.
Actually, let's see THAT test. 😉 I already posted mine.
--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)

July 13, 2009 at 8:24 am

#1023910
RE: Split string using XML

Kindred spirit, Goldie. 🙂
--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)

July 13, 2009 at 8:13 am

#1023900
RE: The Worst Advice

rf44 (7/12/2009)
Maybe I should precise that I never intended to promote or even condone the use of cursors. I know that cursors are not efficient tools in MS SQL Server...
--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)

July 13, 2009 at 6:55 am

#1023838
RE: The Worst Advice

rf44 (7/11/2009)
Answering "never, ever use a cursor" or something equally smart.
The poster did not ask for a personal opinion about cursors (even if it's a wise one), he asked 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)

July 12, 2009 at 7:57 am

#1023612
RE: The Worst Advice

Dave Ballantyne (7/11/2009)
Only heard it once , but it was from a trainer on a vb .net course from one of the largest training companies in the uk.
Dont use...
--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)

July 12, 2009 at 7:49 am

#1023611
RE: The Worst Advice

Charles Kincaid (7/10/2009)
If you got Jeff, Joe, Andy, Phil, and Steve in a a single room the angels would not commence singing and no sparkly glowing would start.
Heh... I think...
--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)

July 10, 2009 at 4:48 pm

#1023426
RE: Are the posted questions getting worse?

Paul White (7/10/2009)
Sometimes, MVP = Mighty Vacuous Post
Thread Link
So I couldn't resist - sue me! :laugh:
Heh... there are 10 types of MVP's... those that know, and those that don't. ...
--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)

July 10, 2009 at 9:54 am

#1023169
RE: DBCC IND - how can I run it when there is a locked row in the table I am looking at?

Gaby Abed (7/10/2009)
2) be prepared in case Microsoft suddenly removes an undocumented feature in the next version of SQL Server (and sometimes even in the next Service Pack)
Shoot.... be prepared...
--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)

July 10, 2009 at 9:52 am

#1023167
RE: How to find Total Number of Tables in All the databases on a Server?

apat (7/9/2009)
Hello All,
How to find total number of tables in each database for all the databases on one particular server?
Thanks,
apat
I've seen this question from various folks over the years 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)

July 9, 2009 at 5:58 pm

#1022799
RE: Job Interview Questions

In most cases (there are exceptions), claims to SQL by other than people interviewing specifically for SQL Developer or DBA usually mean that they were actually in the same room...
--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)

July 9, 2009 at 5:56 pm

#1022796
RE: set commands

Duplicate post. Please don't post replies here. Instead, see the following URL...
http://www.sqlservercentral.com/Forums/Topic750661-146-1.aspx
--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)

July 9, 2009 at 5:38 pm

#1022790
RE: Saving Query results as CSV file in SQL Server 2005

What type of object is qry_Healthstream?
--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)

July 9, 2009 at 5:11 pm

#1022778
RE: Code Cut and Paste

Just testing...
/**********************************************************************************************************************
Purpose:
Returns a single result set similar to sp_Space used for all user tables at once.
Notes:
1. May be used as a view, stored procedure, or table-valued...
--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)

July 8, 2009 at 10:34 pm

#1022135
RE: How to customize "Order By" in my select query?

GSquared (7/8/2009)
Here's where I got that it might be deprecated: http://iablog.sybase.com/paulley/2009/01/more-transact-sql-features-bite-the-dust/
Here's the source for that: http://www.sqlmag.com/Articles/ArticleID/100697/pg/1/1.html (Subscription required)
But it's not on the official deprecations page, so far as I can...
--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)

July 8, 2009 at 10:13 pm

#1022128
RE: How to customize "Order By" in my select query?

That's also what I get from the article. I never do an order by that uses ordinals like that, but I see no reason for them to remove it.
There...
--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)

July 8, 2009 at 10:12 pm

#1022127

Viewing 15 posts - 43,051 through 43,065 (of 59,098 total)