Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,401 through 26,415 (of 59,099 total)

RE: CTE

rahulraghvn (7/20/2013)
CTE, temp table with index or table variable... which one is more performant?
None of the above. Use the XML method that was posted.
--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)

July 20, 2013 at 4:39 pm

#1634277
RE: White space

mikej 14403 (7/20/2013)
Thanks, for you time answering my question.
After creating a csv file, importing it into a Excel spreadsheet and finally importing it into a SQL table I notices white...
--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)

July 20, 2013 at 4:35 pm

#1634276
RE: Hiring Heterogeneously

I found the opposite to be true in some cases. You really really need to be careful that you don't end up with a "Tower of Babel" when hiring...
--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)

July 20, 2013 at 4:11 pm

#1634273
RE: Is this syntax guaranteed to continue working?

Adi Cohn-120898 (7/9/2013)
Jeff – Sorry for disappearing, but for some reason I missed your response. What I wanted to do was very simple. I was working on improving...
--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)

July 20, 2013 at 1:47 pm

#1634266
RE: Tempdb issue

kevaburg (7/19/2013)
Steve-3_5_7_9 (7/10/2013)
kevaburg (7/9/2013)
There is nothing to worry about. TempDB is recreated each time the instance/server is restarted and it will consume however much space it requires to perform...
--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)

July 19, 2013 at 7:28 pm

#1634228
RE: Truncate permission only on specified tables

Eugene Elutin (7/19/2013)
BoL clearly explains what can be done:
Permissions
The minimum permission required is ALTER on table_name. TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server...
--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)

July 19, 2013 at 6:44 pm

#1634227
RE: Formatting Dates with 3 Character Months (SQL Spackle)

Miles Neale (7/19/2013)
I had not seen this previously when it was posted on the site. It is great -> Thanks!
Thanks for the feedback, Miles. I appreciate 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)

July 19, 2013 at 11:53 am

#1634141
RE: Formatting Dates with 3 Character Months (SQL Spackle)

j-1064772 (7/19/2013)
Jeff:
Yet another sterling article!
I do not even need all the fingers on one hand to count the authors I have occasionally corresponded with.
You definitely stand out among the crowd.
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)

July 19, 2013 at 11:50 am

#1634138
RE: CTE and totals for an Accouting plan

If I'm looking at your problem correctly, the following article should help...
http://www.sqlservercentral.com/articles/T-SQL/94570/
--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)

July 19, 2013 at 8:03 am

#1634040
RE: How to take backup of Single table and how to restore?

Luis Cazares (7/19/2013)
udayroy15 (7/19/2013)
Think export the table in xls then import it .........is the best solution
Are you crazy?
BWAAA-HAAA!!!! (Sorry, did that come out loud?)
--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)

July 19, 2013 at 7:51 am

#1634034
RE: Formatting Dates with 3 Character Months (SQL Spackle)

IgorMi (7/19/2013)
Hi Jeff,
Another useful article, Thank You!
I repeated your work on my machine and the improvement was between 1.5 and 1.7 times.
Regards,
IgorMi
Thank you for the great feedback and the timing...
--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)

July 19, 2013 at 7:36 am

#1634022
RE: Formatting Dates with 3 Character Months (SQL Spackle)

Geoff A (7/19/2013)
fregatepallada (7/19/2013)
Guys, did somebody mention this 😉 (valid only in SQL Server 2012):
-- Current date
DECLARE @d DATETIME = GETDATE();
SELECT FORMAT( @d, 'dd MMM yyyy', 'en-US' ) AS...
--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)

July 19, 2013 at 7:25 am

#1634016
RE: Formatting Dates with 3 Character Months (SQL Spackle)

Irozenberg 1347 (7/19/2013)
Geoff A (7/19/2013)
fregatepallada (7/19/2013)
Guys, did somebody mention this 😉 (valid only in SQL Server 2012):
-- Current date
DECLARE @d DATETIME = GETDATE();
SELECT FORMAT( @d, 'dd MMM yyyy', 'en-US'...
--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)

July 19, 2013 at 7:17 am

#1634009
RE: using between on string columns

Here's your string example with the proper justification for jusing BETWEEN for such things. It returns the correct value, as expected.
declare @t table(Start varchar(10)
...
--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)

July 17, 2013 at 9:00 pm

#1633504
RE: using between on string columns

It's because the leading "2" falls between the leading "1" and the leading "5". You would need to LPAD the contents of the table and the string contained 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)

July 17, 2013 at 8:51 pm

#1633501

Viewing 15 posts - 26,401 through 26,415 (of 59,099 total)