Jeff Moden

Forum Replies Created

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

RE: Convert nanoseconds since 1/1/1601

Jeff Moden (8/7/2008)
You mean to tell me that LDAP queries can't change the format of the date?
BWAAA-HAAA!!!! I guess a more than 5 year wait for an answer means,...
--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 7:03 pm

#1673442
RE: SQL server 2005 get slow after rebuild index online on few tables

If the job that does the 120 row/minute processing is either inserting or updating the rows on the tables in question AND the indexes have a 100% FILLFACTOR, then 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)

December 13, 2013 at 6:46 pm

#1673441
RE: Long Path Names to Files on SQL Server Installation

cathy.baker (12/13/2013)
I renamed the folder that was WAY long to something shorter and simpler then mapped the drive. That fixed the problem.
Thanks for the feedback, Cathy.
--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:33 pm

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

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