Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,626 through 44,640 (of 59,101 total)

RE: sql_variant

Florian Reischl (3/14/2009)
Hi
I'm using sql_variant alike Jeff stated for logging. I've got a usp_Log like this:
CREATE PROCEDURE dbo.usp_Log
@msg VARCHAR(4000),
@p1 SQL_VARIANT = NULL,
...
--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)

March 14, 2009 at 8:38 am

#959717
RE: Are the posted questions getting worse?

Bob Hovious (3/13/2009)
I tried to take the high road for a change. However, I am ready to buy a round for Sergiy 🙂
Heh... Sergiy... I've learned...
--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)

March 13, 2009 at 11:28 pm

#959631
RE: T-Sql rant

foxjazz (3/13/2009)
Why couldn't they write t-sql more like C# or have a flavored compiler for t-sql so that we could work it like c# or vb depending on how 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)

March 13, 2009 at 11:18 pm

#959630
RE: Are the posted questions getting worse?

Steve Jones - Editor (3/13/2009)
So I got a question in email (it's not just posters, I get them regularly). I have a sig I paste in that replies and says...
--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)

March 13, 2009 at 11:15 pm

#959629
RE: Are the posted questions getting worse?

GilaMonster (3/13/2009)
Am I being too harsh here?
http://www.sqlservercentral.com/Forums/FindPost675279.aspx
Absolutely not...
--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)

March 13, 2009 at 11:13 pm

#959628
RE: Are the posted questions getting worse?

Steve Jones - Editor (3/13/2009)
I'm torn here. I wouldn't be surprised if he got the job since most candidates can't answer those questions. At least not from the stories I...
--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)

March 13, 2009 at 11:00 pm

#959626
RE: Urgent : Sql server db tuning

Yeah... I'm still curious, too. Someone posted a suggestion to use Java on this and, as I asked in a previous post on this thread, I'd really like to...
--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)

March 13, 2009 at 10:51 pm

#959625
RE: Select distinct row on SQL 2000. Please help me!

There are many solutions on this thread, so we're not sure which solution you're talking about.
While I "have you on the phone", can you tell me what the business requirements...
--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)

March 13, 2009 at 10:42 pm

#959623
RE: SQL Server 2005 Paging – The Holy Grail

For my ends, the 'holy grail' approach is absolutely the fastest and most efficient technique
Heh... sure... 7 to 8 seconds compared to just over a second. I'm sure...
--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)

March 13, 2009 at 10:38 pm

#959621
RE: sql_variant

Steve Mong (3/13/2009)
Certain classes of apps can't anticipate the data types they'll be required to store, manipulate, etc.
Master Data Management apps have always been prominent examples (wherein Oracle's product...
--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)

March 13, 2009 at 10:31 pm

#959619
RE: split date and time from datetime

vijays (3/13/2009)
select convert(datetime, convert(float, getdate()) - floor(convert(float, getdate())))
Unfortunately, this is one of the posts where the original post made by the OP isn't even close to what the OP actually...
--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)

March 13, 2009 at 6:25 am

#959031
RE: How do I select a specific entry from a select top nn statement

RBarryYoung (3/11/2009)
PeterR (3/11/2009)
OK Jeff - Why is it necessary?
(Hope I got the question right)
Since that wasn't the question that Jeff wanted, I'll answer this one, ...:D
They are necessary because all...
--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)

March 13, 2009 at 12:15 am

#958918
RE: Please clarify

prvreddy (3/12/2009)
Hi guys,
Yesterday, I attended one interview for DBA.I got following questions.But i didn't answers these questions.Please help me in this regard.
1)if log file fills 100% then how...
--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)

March 13, 2009 at 12:09 am

#958917
RE: Are the posted questions getting worse?

Grant Fritchey (3/12/2009)
My favorite snooty response, mainly because I've received it several times, "You're being far too SQL Server specific. What happens when you need to switch platforms?"
My favorite...
--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)

March 12, 2009 at 9:41 pm

#958896
RE: Are the posted questions getting worse?

Alvin Ramard (3/12/2009)
Steve Jones - Editor (3/12/2009)
I'm just glad they're coming here instead of Google first 🙂
Yeah. You can buy pork chops in bulk now and get a much...
--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)

March 12, 2009 at 9:32 pm

#958895

Viewing 15 posts - 44,626 through 44,640 (of 59,101 total)