Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,521 through 23,535 (of 59,099 total)

RE: Database Design Best Practice Question

SQL Shibe (5/30/2014)
I am building out a database (please see sample attachment) and I am second guessing myself on my database design and would like to get a second opinion...
--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)

May 30, 2014 at 11:25 pm

#1718000
RE: Sp & parameters

ramana3327 (5/30/2014)
Hi,
I am working with SP. How can we find out values of parameters when the SP is executed with the default values?
If I understand your question correctly, the defaults...
--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)

May 30, 2014 at 10:43 pm

#1717996
RE: SQL Challenge: Updating parts of fields.

Eirikur Eiriksson (5/30/2014)
Raymond.Pietrzak (5/30/2014)
I was able to write my query against the VarChar(4000) data type. This worked.
Update [WBPROD].[dbo].[TASK_SCHEDULE]
Set TSKSCD_DESCRIPTION = Replace(TSKSCD_DESCRIPTION, '<timezoneId>0</timezoneId><timezone>America/New_York</timezone>', '<timezoneId>1</timezoneId><timezone>America/Chicago</timezone>')
Update [WBPROD].[dbo].[TASK_SCHEDULE]
Set TSKSCD_DESCRIPTION = Replace(TSKSCD_DESCRIPTION,
...
--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)

May 30, 2014 at 10:36 pm

#1717994
RE: SQL Challenge: Updating parts of fields.

A much better solution would be to "normalize" the XML as a real table with real columns and rows.
--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)

May 30, 2014 at 10:13 pm

#1717990
RE: SQL Database Size 0 and Unallocated space in negative ..how to Free up?

1. What recovery model is the database in?
2. What type(s) of backups are you running?
3. What are you doing for index maintenance?
4. How big is TempDB?
5....
--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)

May 30, 2014 at 10:06 pm

#1717989
RE: t-sql 2008 exlain select

Heh... not to worry. I started out by testing the other solutions and then went back to the original solution. I kept looking at it and asking myself...
--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)

May 30, 2014 at 9:25 pm

#1717987
RE: t-sql 2008 exlain select

sgmunson (5/29/2014)
The string it returns tells you which bits would be set to 1 in the binary equivalent of the input number (tMask, presumably coming from the table). ...
--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)

May 30, 2014 at 8:30 pm

#1717984
RE: Farewell

Steve Jones - SSC Editor (5/30/2014)
david.gugg (5/30/2014)
Be sure to spend at least one day doing nothing but fishing!
LOL, it only takes me 2 min to pick out a tuna steak...
--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)

May 30, 2014 at 5:53 pm

#1717979
RE: Insert Select statement

To the best of my knowledge, nothing in OPENROWSET can be a variable. It either needs to be hard-coded or be dynamic SQL. As previously suggested, be careful...
--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)

May 29, 2014 at 2:47 pm

#1717598
RE: Difference in performance via Pofiler to SSMS

At this point, I recommend that you read the article at the second link under "Helpful Links" in my signature line below so that we may help you with 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)

May 29, 2014 at 2:45 pm

#1717597
RE: Decimal(65,2) in MySQl to Sql server Data Type

Mr. Kapsicum (5/29/2014)
Hi,
This Data Type is of the Source Table. We Insert Data from Mysql DB to SQL Server.
The Data Type for few columns in Source Table is Decimal(65,2), so...
--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)

May 29, 2014 at 2:28 pm

#1717584
RE: Please help this slow and cumbersome query

Not to mention that each delete will probably cause a full scan of the Temp Table because there are no indexes. It's far better to isolate what you want...
--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)

May 29, 2014 at 1:09 pm

#1717537
RE: How to add column in specific position

Almost forgot. BULK INSERT has all the same capabilities for importing that BCP has. In the early days, it didn't allow for the sequestration of errors in error...
--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)

May 29, 2014 at 1:00 pm

#1717530
RE: How to add column in specific position

You bet and thank you for the feedback, Joe. Us "old dogs" gotta stick together. 😛
--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)

May 29, 2014 at 12:50 pm

#1717522
RE: How to add column in specific position

DataJoe (5/29/2014)
Ok teach "the old dog" a new trick.
I know of format files yes however, I have now learned that using a format file ignores my truncation error which in...
--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)

May 29, 2014 at 12:27 pm

#1717509

Viewing 15 posts - 23,521 through 23,535 (of 59,099 total)