Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,171 through 25,185 (of 59,099 total)

RE: How to find SQL job are in progress.

This can be a lengthy process. The first step that I'd take would be to see if there's any blocking in the database by running sp_Who2.
--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)

December 13, 2013 at 6:32 pm

#1673439
RE: Create a View with OPTION (FORCE ORDER)

Lowell (12/13/2013)
h.tobisch (12/13/2013)
use option (force order) when selecting from the view
note: eight year old thread.
If the suggestion works, who cares how old the thread is? 😉
--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)

December 13, 2013 at 6:24 pm

#1673438
RE: Entering Value by the User

What language are you using to present the message and store the answer? SQL Server isn't real handy about doing things that should be done in the GUI. ...
--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)

December 13, 2013 at 6:18 pm

#1673437
RE: Update Query Date Range

scotsditch (12/13/2013)
Also I'm a little new to forums, could you give me a tip on how you get your query to format so nicely when it displays on the forum...
--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)

December 13, 2013 at 6:15 pm

#1673436
RE: Patching

dan-572483 (12/12/2013)
I don't like the idea of killing jobs midway. Depending on what they do, partially completed jobs might be problematic.
I'd prefer to disable in advance any jobs 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)

December 13, 2013 at 5:49 pm

#1673433
RE: Partitioned Views

"Worktable" is a table created in TempDB by the system to make things like hash tables for hash joins and other temporary objects.
--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)

December 13, 2013 at 5:45 pm

#1673432
RE: odd situation

aaron.reese (12/11/2013)
Oops!
I should know better than to make throwaway statements like that when Jeff or Gill are lurking 😀
I will have to find some time to set it up on...
--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)

December 13, 2013 at 5:43 pm

#1673431
RE: CPU is higher than ever.

Penserver (12/11/2013)
we recently moved from 4 to 8 cores on the SQL server 2008 db in a vm environment (at hosting.com). CPU has been higher than ever.
What could 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)

December 13, 2013 at 5:37 pm

#1673430
RE: copy job fails

cpathidba (12/10/2013)
Thanks Jeff Moden the problem solved.
Ok... How was the problem solved?
--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)

December 13, 2013 at 5:35 pm

#1673429
RE: what's the name for this type of table used in the following way?

Staging table.
--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)

December 13, 2013 at 4:42 pm

#1673422
RE: Unable to Kill inactive session.

Talib123 (12/13/2013)
If the spid is a minus number you have an ORPHANED Distributed Transaction.
I will explain how to kill that if that is the case
Cool... Let's hear 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)

December 13, 2013 at 4:40 pm

#1673421
RE: How important are log and database backups in a production environment?

I agree with Sean.
I'll also add that, if the company continues to resist the upgrade of a 13 year old product, it's time to get 3 envelopes... 😉
--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)

December 13, 2013 at 4:25 pm

#1673417
RE: add primary key to heap question

You might be able to use the ONLINE option if the VARBINARY column is NOT a blob.
What is the partitioning column and function based on? Month's for ever increasing...
--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)

December 13, 2013 at 4:15 pm

#1673416
RE: Patching

Ratheesh.K.Nair (12/11/2013)
Thanks Jeff,
My confusion is whether its good practice to reboot the whole server without stopping SQL Server or its ok with the above said steps?
Ah, understood.
I probably play...
--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)

December 11, 2013 at 9:55 pm

#1672821
RE: Dumb Vocab Question about What This Type of Table is Called

As with all else, "It Depends". Please see the latest article from Tony on the subject.
http://www.sqlservercentral.com/articles/Editorial/105414/
I agree that they are a panacea for nothing and usually cause a whole...
--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)

December 11, 2013 at 4:25 pm

#1672786

Viewing 15 posts - 25,171 through 25,185 (of 59,099 total)