Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,961 through 39,975 (of 59,098 total)

RE: Coding By The Sea

There are a lot of people at work that I get along with really, really well and we've all had some great times together both at work and outside of...
--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 4, 2010 at 5:22 am

#1113641
RE: Keeping It All In Memory

Instrumented data collection apps, especially in the medical and device control fields, would greatly benefit from IMDB instances as well.
--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 4, 2010 at 5:10 am

#1113635
RE: T-SQL Stored Proc calling T-SQL Function

Lynn Pettis (2/3/2010)
mark.veitch (2/1/2010)
Thank you very much Lowell. Just had a quick scan and although this is new to me I'm thinking it might be a possibility. About...
--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 9:40 pm

#1113439
RE: Column With Multiple Values

If the data is actually as you say it is, then using Wayne's good test data, you can cheat like hell 😉
-- notice how a table is defined (DDL) 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)

February 3, 2010 at 9:15 pm

#1113427
RE: convert flat file (.cvs) to SQL Server 2005 using SSIS

Ummmm.... isn't there a text qualifier setting that can be enabled?
--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 9:08 pm

#1113423
RE: Hardware requirements

David Lester (2/3/2010)
Thank you all for the tips and suggestions. It is good to see that there are others who, like me, think the hardware is cheap enough at 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)

February 3, 2010 at 9:05 pm

#1113419
RE: sql saturday and PASS mariage news

Steve Jones - Editor (2/3/2010)
We gave the SQLSaturday event and infrastructure to PASS. I'm sure they'll announce it at some point today or tomorrow.
http://www.sqlservercentral.com/blogs/steve_jones/archive/2010/02/02/sqlsaturday-bequeathed-to-pass.aspx
We are hoping PASS will continue 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 9:00 pm

#1113416
RE: Extreme SSIS Newbie needs help with a super simple conditional insert

Dan Guzman - Not the MVP (2/3/2010)
PS Jeff, someday I'll post my real world 'I bet you can't get rid of this cursor/while loop' stumper
I'd imagine that a lot...
--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:58 pm

#1113415
RE: INT to Bit

As a side bar, I don't use the BIT datatype for the most part. A single bit still takes a byte to store it and you can't so SUM...
--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:53 pm

#1113413
RE: SQL Script

gsanthosh84-663713 (2/3/2010)
Hi,
Below is the data in my table
MarketQtrWeek % Over %Change
HD Q1'09 1 3.91% 3.91%
HD ...
--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:50 pm

#1113412
RE: Table truncation

As a side bar, you don't need to actually drop the constraints... you can disable them with ALTER TABLE and NO CHECK.
--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:43 pm

#1113411
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

Viewing 15 posts - 39,961 through 39,975 (of 59,098 total)