Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,111 through 19,125 (of 59,098 total)

RE: Remove time(date)

jcachado (11/27/2015)
Jeff Moden (11/27/2015)
BrainDonor (11/27/2015)
That was just an example, using a SQL Server date function.
What does FORMAT(create_dtim,'dd-MM-yyyy')do?
Just so you know, FORMAT is 44 times slower than either CAST or CONVERT.
Thks...
--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)

November 27, 2015 at 8:40 am

#1842652
RE: Query results

anthony.green (11/27/2015)
Dont use undocumented features your setting yourself up for a fall should MS remove them, they are not documented so they dont tell us if they are going 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)

November 27, 2015 at 8:15 am

#1842646
RE: Remove time(date)

BrainDonor (11/27/2015)
That was just an example, using a SQL Server date function.
What does FORMAT(create_dtim,'dd-MM-yyyy')do?
Just so you know, FORMAT is 44 times slower than either CAST or CONVERT.
--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)

November 27, 2015 at 8:02 am

#1842639
RE: How to run a view every 1000 rows to add in table?

There's just not enough information to even begin to make a suggestion here. For example, we don't know what D_CalendarSKey is nor why there'd be a stock related subkey...
--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)

November 27, 2015 at 8:00 am

#1842638
RE: Thanks

Gary Varga (11/27/2015)
As usual Steve covers a topic pretty well without closing the door and leaving us plenty of room to offer our own opinions.
I'd like to thank all 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)

November 27, 2015 at 7:49 am

#1842635
RE: Stairway to SQLCLR Level 1: What is SQLCLR?

I always wondered why the FORMAT function was so slow. Now I know. 🙂
--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)

November 27, 2015 at 7:42 am

#1842631
RE: how to select all record in query

immaduddinahmed (11/27/2015)
hi,
i want to select all data in where clause.
can any one provide me a syntax.
please help me out.
thanks for the help.
This is a bit like telling someone 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)

November 27, 2015 at 7:32 am

#1842628
RE: Accidentally set max server memory to 0

webrunner (11/24/2015)
Thanks for this thread. I realize that being careful is the way to avoid this issue, but my question is, why is this change even possible in SQL 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)

November 26, 2015 at 9:20 am

#1842529
RE: Trigger result from inserted / Deleted

Jack Corbett (11/25/2015)
Why are you returning results from a trigger? The ability to return results from triggers has been deprecated. From BOL:
There goes yet another great...
--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)

November 25, 2015 at 12:23 pm

#1842389
RE: Good Basic T-SQL Exercises

I keep trying to write an exercise or two but I keep coming up with things that are already in many of the articles, thanks to the people that post...
--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)

November 22, 2015 at 10:21 am

#1841561
RE: Rename a network file using xp_cmdshell

Lowell (11/6/2015)
i seem to remember that xp_cmdshell is limited to a single set of double quotes, right?
so "\path with spaces\oldname" "\path with spacesewname" might return an error?
No. Each path...
--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)

November 22, 2015 at 9:38 am

#1841558
RE: Pivot One Row Field for All Rows Containing Same Time

o324712 (11/22/2015)
All data you would need is there. I don't have any DDL's as this is a sample. The original table if I had one would be the first 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)

November 22, 2015 at 9:17 am

#1841557
RE: Find Tables That Should Have Indexes ?

homebrew01 (11/21/2015)
I found a table that should have had some indexes to improve performance. So now I'm wondering what other tables could benefit. I can get a list of tables...
--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)

November 21, 2015 at 5:33 pm

#1841540
RE: Copy of 1 TB prod database

tripleAxe (11/18/2015)
In my experience backup time was significantly reduced. I had a 1TB database that was taking 5 hours to backup. Changed the backup to stripe to 8...
--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)

November 21, 2015 at 5:12 pm

#1841538
RE: Identifying Rock/Paper/Scissors Scenarios

jmpatchak (11/20/2015)
Hi Alan,
This does a really great job of generating random test data. What I'm looking for is a query that pulls out the data from the Battle table 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)

November 21, 2015 at 5:05 pm

#1841537

Viewing 15 posts - 19,111 through 19,125 (of 59,098 total)