Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,736 through 24,750 (of 59,099 total)

RE: Importing .CSV from Symantec Q&A v4.0 (legacy flat dbms)

BR.GRIFFITH (1/16/2014)
Can I do anything differently in T-SQL/Bulk INSERT that will override this error and just leave a field or two blank and import the majority of the flat file...
--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)

January 17, 2014 at 6:52 pm

#1681316
RE: SQL single column rows into multiple columns

Johnny D (1/17/2014)
Hi All,
I have a table with one column with lots of rows. I would like every five rows of data to turn into five columns.
So in example if...
--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)

January 17, 2014 at 6:29 pm

#1681315
RE: Multiple Pivots

singh.kamaldeep (1/16/2014)
Hi SQL Gurus,
I am struck into one major issue.
I have data in my table as follows.
BOM_STATION_NO STD_DT TIME PERIOD_ID TEMP ...
--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)

January 17, 2014 at 4:35 pm

#1681304
RE: We're not craftsmen and craftswomen

David.Poole (1/17/2014)
I always do the best I can do within the constraints I am given. If it is time and resource constraints and I know that these are 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)

January 17, 2014 at 4:22 pm

#1681301
RE: Picking Your Packaging

Hands down, it would be T-SQL for me with calls from there to PoSh and only if needed. T-SQL doesn't seem to change as much as all the other...
--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)

January 17, 2014 at 4:07 pm

#1681299
RE: foreach loop container - BIDS 2010

This appears to be a duplicate thread, which splits up the answers. Please, no more replies on this thread. Please post your answers at the following thread.
http://www.sqlservercentral.com/Forums/Topic1530927-148-1.aspx
--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)

January 17, 2014 at 3:59 pm

#1681296
RE: ProperCase Function

BWAAA-HAAA!!!! Dare I say IT? DARE I? Oh, what the heck...
[font="Arial Black"]"Ahhhhhhh MAGOO! You've done it again." [/font]:-P (Sorry ol' friend... I've been holding it back for...
--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)

January 17, 2014 at 3:52 pm

#1681294
RE: Reclaim free space

Casper101 (1/17/2014)
Yes, it has a clustered and a few non-clustered indexes.
I did rebuild all indexes on this table.
I will apply your script to my DB..hope it works..
Thanks for you help...
--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)

January 17, 2014 at 3:39 pm

#1681291
RE: Concatenating field values in one string

In that case, let's provide a link on the subject.
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
Please make sure that you dive into the "Join the Discussion" link for a particular performance optimization.
As for the dupes, "It...
--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)

January 17, 2014 at 3:28 pm

#1681289
RE: Best way to graph/draw an ETL data flow

PLEASE stop double posting on this site. Many of us monitor all forums on this site and your duplicate posts just split up answers.
No replies here, please. Please...
--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)

January 17, 2014 at 3:21 pm

#1681285
RE: Very SIMPLE query working in Access not working on Sql Server

dquirion78 (1/17/2014)
wow thanks I just tried some test on computed columns... Sql server is so strong 🙂
thanks again
If you can't add PERSISTED Computed Columns to your table for some...
--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)

January 17, 2014 at 3:17 pm

#1681283
RE: Copy logins with their password

SQL_Surfer (1/17/2014)
I need to copy some databases from one server to another. What is the best way to copy logins with their passwords? Each login has access to multiple databases...
--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)

January 17, 2014 at 3:04 pm

#1681277
RE: Extent Scan Fragmentation

From what I understand, fragmentation calculations at the extent level were actually flawed in DBCC SHOWCONTIG and that fragmentation detection in sys.dm_db_index_physical_stats is actually more accurate.
--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)

January 17, 2014 at 2:41 pm

#1681271
RE: Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)

Crud. I just noticed a limitation and I need to post another correction to the article. I tested for all dates from 1900-01-01 00:00:00.000 through 9999-12-31 23:59:59.997. ...
--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)

January 16, 2014 at 10:07 pm

#1680954
RE: Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)

Since there was some interest in correctly calculating the duration even if the start and end dates were reversed, here's a function that straightens that out. Personally, I'd 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)

January 16, 2014 at 9:40 pm

#1680953

Viewing 15 posts - 24,736 through 24,750 (of 59,099 total)