Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,251 through 47,265 (of 59,095 total)

RE: Help writing function to get decimal from string

Garadin (11/14/2008)
Not sure if Jeff is gonna slap me for this one, but we'll see.
Heh... firing porkchop #1... [font="Arial Black"]SLAP![/font] 😛 Ya gotta put a clustered index or, better yet,...
--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)

November 14, 2008 at 9:04 am

#898685
RE: CPU Utilization is 100% !!!!

Along with the other suggestions, I'd also take the time to upgrade to at least Service Pack 2. From what I saw on my own machine, SP2 fixed a...
--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)

November 14, 2008 at 8:42 am

#898666
RE: Time to ReIndex

Heh... no, not a waste. In fact, thank you very much! I now know how long it takes to create an index on an INT column that has...
--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)

November 14, 2008 at 8:38 am

#898661
RE: calling xp_fixeddrives on a remote server

Oh yeah... almost forgot...
The "AT linked_server_name" probably cannot be a variable... you'll need to use dynamic SQL to create the EXEC's, and then execute the dynamic SQL. That 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)

November 14, 2008 at 8:32 am

#898653
RE: calling xp_fixeddrives on a remote server

Damned smiley faces... wish they could fix that...
Here's the listing without the smiley...
[font="Arial Black"]Execute a pass-through command against a linked server[/font]
{ EXEC | EXECUTE }
...
--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)

November 14, 2008 at 8:27 am

#898649
RE: calling xp_fixeddrives on a remote server

I've never had to do that before but, according to BOL, here's the correct syntax for how to do it...
[font="Arial Black"]Execute a pass-through command against a linked server[/font]
{ EXEC |...
--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)

November 14, 2008 at 8:25 am

#898645
RE: Find out which table columns were inserted from within a trigger

I also checked the UPDATE() function (you never know)... the one that checks per column... same disappointment...
DROP TABLE dbo.TriggerTest
GO
CREATE TABLE dbo.TriggerTest (ColA INT, ColB INT)
GO
CREATE TRIGGER MyTrigger
...
--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)

November 14, 2008 at 8:20 am

#898637
RE: Find out which table columns were inserted from within a trigger

Wow... I just tried it...
CREATE TABLE dbo.TriggerTest (ColA INT, ColB INT)
GO
CREATE TRIGGER MyTrigger
ON dbo.TriggerTest
AFTER INSERT, UPDATE
AS
SELECT COLUMNS_UPDATED()
GO
INSERT INTO...
--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)

November 14, 2008 at 7:57 am

#898610
RE: Help! TempDB just keeps on growing

When you guys made the "new" TempDB, did you make sure it was still set to the "Simple" recovery mode?
--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)

November 14, 2008 at 12:13 am

#898425
RE: Custom Password Policy Stored Procedure Needed

Heh... loops... IF's... RBAR...
The hard part is figuring out how many of each character type is in the password and the following code figure that out nicely. You 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)

November 14, 2008 at 12:09 am

#898423
RE: Concat mutiple rows into one row

See the following article for how to do the CSV concatenation along with some pitfalls to avoid...
http://www.sqlservercentral.com/articles/Test+Data/61572/
To help us give you a better/tested answer, take a look at the link...
--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)

November 13, 2008 at 11:38 pm

#898414
RE: Update one table based on another table

Can you show what you've tried, so far?
--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)

November 13, 2008 at 11:34 pm

#898411
RE: update and "if...else" clause?

UPDATE t5
SET UpdateField = CASE
...
--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)

November 13, 2008 at 11:32 pm

#898409
RE: Introduction to DML Triggers

timothyawiseman (11/13/2008)
Heh. Robert and Mohit have a point. Instead of triggers views could be used to let a legacy application interact with and change the data in 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)

November 13, 2008 at 7:58 pm

#898384
RE: Exporting resultset of temp table to other formats. How?

sql-oholic (11/13/2008)
if i change temp table to global temp table, it works.
It's been a while since I've had to do such a thing, but that just doesn't seem right 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)

November 13, 2008 at 7:53 pm

#898383

Viewing 15 posts - 47,251 through 47,265 (of 59,095 total)