Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,946 through 39,960 (of 59,072 total)

RE: Coding By The Sea

live with a few people at work,
Heh... shoot... why would I want to do that? I see them too much as it is. If you want productivity 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)

February 3, 2010 at 8:37 pm

#1113410
RE: INT to Bit

Tara-1044200 (2/2/2010)
I dont have any indexes on any tables in that database.
Can you some one give correct explanation as to why space is not released when some column are deleted?
Tara-1044200...
--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)

February 3, 2010 at 8:23 pm

#1113404
RE: Calling a powershell script from TSQL

Restricting xp_CmdShell is probably a good idea but proxies can be setup to allow calling of stored procedures that use it without exposing xp_CmdShell to most users. I 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)

February 3, 2010 at 7:58 pm

#1113395
RE: sql server very slow

I'm going with Elliot on this one. It sounds like a classic memory leak either caused by an app, a CLR (whatever you want to call it), or perhaps...
--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)

February 3, 2010 at 7:55 pm

#1113394
RE: Really complicated select statement

lmu92 (2/3/2010)
I'm not sure if I'm heading in the right direction...
If you want to see all order numbers with different values then you could use something like the following (untested,...
--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)

February 3, 2010 at 7:46 pm

#1113388
RE: Run a stored procedure from BCP

Perhaps include a fully qualified schema name instead of just "dot dot"?
--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)

February 3, 2010 at 7:00 pm

#1113370
RE: How to bulk insert rows from text file into a WIDE TABLE which has 1400 columns?

Welsh Corgi (2/3/2010)
Have you tried using a format file with the BCP Utility?
I believe that Welsh's idea above could be one of the simplest and fastest ways. ...
--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)

February 3, 2010 at 6:56 pm

#1113369
RE: Calling a powershell script from TSQL

xp_CmdShell (I believe) but why would you want to do that?
--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)

February 3, 2010 at 6:50 pm

#1113368
RE: Column With Multiple Values

BaldingLoopMan (2/3/2010)
if the model will always be the second value in the delimited list then i would go online and bring down the split function. Which is below
---------------------------------------------------------------------
CREATE FUNCTION dbo.Split
(
@RowData...
--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)

February 3, 2010 at 5:48 pm

#1113360
RE: BCP utility

Shark Energy (2/3/2010)
I'm not 100% sure it will work but copy the files bcp.exe and bcp.rll from the SQL Server\Tools\Binn folder on the db server and place them on your...
--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)

February 3, 2010 at 5:30 pm

#1113357
RE: Paying attention to detail and being thorough.

It's real hard to come up with a more meaningful post on this subject than what the two of you have already so I'll leave my rant about this right...
--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)

February 3, 2010 at 5:27 pm

#1113355
RE: Indexing fields for JOINS and WHERE

Ohhh... be careful. I just went through a similar thing a month ago. Having an index with a leading column having only two possible states will sure speed...
--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)

February 3, 2010 at 5:05 pm

#1113348
RE: Virtual PM's for Jeff...

I still think it would be a great article. Lots of people run into the same problem.
--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)

February 3, 2010 at 4:37 pm

#1113334
RE: Are the posted questions getting worse?

GilaMonster (2/3/2010)
Um....
http://www.sqlservercentral.com/Forums/FindPost858555.aspx
Heh... that one brought back some bad Oracle discussion memories.
--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)

February 3, 2010 at 4:32 pm

#1113330
RE: Are the posted questions getting worse?

Roy Ernest (2/3/2010)
GilaMonster (2/3/2010)
"I am working in a project nearing to its deadline. I am not having enough time/patience to read books now."
http://www.sqlservercentral.com/Forums/Topic856967-1291-1.aspx
Seriously, where are all the idi^H^H^H novice-type people...
--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)

February 3, 2010 at 4:23 pm

#1113324

Viewing 15 posts - 39,946 through 39,960 (of 59,072 total)