Jeff Moden

Forum Replies Created

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

RE: Rebuilding large index with limited free space

ricardo_chicas (11/20/2015)
Jeff Moden (11/17/2015)
ricardo_chicas (11/9/2015)
Thanks
I will do something similar, add a new file group and move those tables over there
What is the table used for? For example, is 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)

November 20, 2015 at 1:17 pm

#1841452
RE: High percent signal waits with very low cpu usage

dbruton95 (11/19/2015)
I'm investigating a problem that's kind of similar to this. Maybe you've already done this but I would suggest looking at a trace.
We have a front...
--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 19, 2015 at 5:21 pm

#1841237
RE: Are the posted questions getting worse?

Eirikur Eiriksson (11/19/2015)
So to recap, here are 9 different methods for getting the current time, any additions anyone?
😎
SELECT
GETDATE()
,SYSDATETIME()
,SYSDATETIMEOFFSET()
...
--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 19, 2015 at 4:48 pm

#1841232
RE: Good Basic T-SQL Exercises

Ed Wagner (11/19/2015)
Jeff Moden (11/19/2015)
Steve Jones - SSC Editor (11/19/2015)
Here, though not sure how/why/when. I am trying to get some POC together that could be used to help people walk...
--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 19, 2015 at 11:14 am

#1841109
RE: Please help to resolve issue in SQL Query

ChrisM@Work (11/19/2015)
Always test:
+1000
--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 19, 2015 at 11:09 am

#1841107
RE: How to get 'Year' in a case statement

cory.bullard76 (11/19/2015)
Thanks! For the help. I was thinking that I had to put the convert code at the end (ex. Convert(Varchar....101)...so that kept me from doing 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)

November 19, 2015 at 11:05 am

#1841104
RE: UPDATE statement help

Ya just gotta love the way people come together to simplify things on some of these posts. Thanks folks.
--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 19, 2015 at 10:53 am

#1841098
RE: concatenation of two columns as single

Robert vd Berg (11/19/2015)
Is this what your looking for?
SELECTdbo.agent_datetime(run_date, run_time)
FROMsysjobhistory;
You beat me to it. It's not the epitome of efficiency but it's usually good enough. Luis' "iSF" would...
--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 19, 2015 at 9:13 am

#1841047
RE: Good Basic T-SQL Exercises

Steve Jones - SSC Editor (11/19/2015)
Here, though not sure how/why/when. I am trying to get some POC together that could be used to help people walk a path, but be...
--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 19, 2015 at 9:11 am

#1841044
RE: dynamic cursor

Easy guys. 'Tis the season to be jolly. 🙂
--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 19, 2015 at 9:09 am

#1841043
RE: Insert into select from - View

@Minnu,
I don't mean this as a slam. It's a recommendation. This is some pretty basic stuff that you're talking about and, if your job requires you to work...
--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 19, 2015 at 8:45 am

#1841034
RE: UPDATE statement help

ChrisM@Work (11/19/2015)
Shamelessly nicking Jeff's sample data:
--===== If it exists, drop the test table to make reruns easier in SSMS.
-- This is NOT a part of the solution.
IF OBJECT_ID('tempdb..#TestTable','U') IS 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)

November 19, 2015 at 7:00 am

#1840969
RE: UPDATE statement help

serg-52 (11/19/2015)
Jeff Moden (11/18/2015)
I believe that using something like "Lead/Lag" would do the same thing faster but I don't have 2012 on the machine that I'm currently working on 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)

November 19, 2015 at 6:54 am

#1840967
RE: UPDATE statement help

Jason-299789 (11/19/2015)
Jeff,
I dont think Lead/Lag will help in this case as it will only update by a given offset, so using the example
SELECT
#TestTable.*
,LEAD(class4,1,class4) OVER (PARTITION BY identifier ORDER...
--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 19, 2015 at 6:51 am

#1840965
RE: SQL Query question

For future posts, please help us help you. Please read the article at the first link under "Helpful Links" in my signature line at the end of this 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 18, 2015 at 10:25 pm

#1840878

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