Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,081 through 19,095 (of 59,072 total)

RE: query fail after 727855 reads and 30005 duration

amrmnabil74 (11/27/2015)
Thanks patrickmcginnis59 10839
can you tel me how to trace "SQL:BatchCompleted"
and find the error details
coz i only got error code without details
Yes... transfer the code to SSMS, give it 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)

November 28, 2015 at 12:37 pm

#1842725
RE: How To Pivot Not Joined Tables

rootfixxxer (11/28/2015)
So my problem it's that the pivot function needs an aggregate function to work, but what i need it's the current field value...
In this case it could be anything,...
--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 28, 2015 at 12:28 pm

#1842724
RE: This is why SQL Server Central Forums rock!

Absolutely awesome job, YB! Congratulations!
--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 28, 2015 at 12:04 pm

#1842722
RE: Best way to deploy 100+ sql files.

Keep the files separate. It's an advantage that you'll realize later. Just make a batch file that executes the scripts in the order that you want them.
--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 10:43 am

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

Viewing 15 posts - 19,081 through 19,095 (of 59,072 total)