Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,626 through 8,640 (of 59,091 total)

Reply To: Selecting records and true or false value
Here's one simple method provided those are actual NULLs and not just a word of '[NULL]':
```
 SELECT  ProcessID
        ,IsCompleted...
```
--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)
September 21, 2019 at 6:56 pm

#3682292
Reply To: slow database performance
Oh... almost forget... your question was...
vsamantha35 wrote:
My question is, if all the queries are poorly performing. In that case, where do I start my troubleshooting.
The answer is, the system knows. ...
- This reply was modified 6 years, 11 months ago by Jeff Moden.
--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)
September 21, 2019 at 5:19 pm

#3682284
Reply To: slow database performance

I'd worry about memory but not in the way you distributed it. You have a fair number of fairly large databases. Adding memory is generally the single best hardware improvement...
--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)

September 21, 2019 at 5:06 pm

#3682281
Reply To: Query optimization help

My first observation is that there is no index to support this query even if the "table" was in good shape. You could try the following indexes to see if...
--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)

September 21, 2019 at 4:05 pm

#3682273
Reply To: Heap rebuilds

To answer your question, there will be no difference in performance or resource usage. The only difference is that the first rendition could be created as a stored procedure 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)

September 21, 2019 at 2:49 pm

#3682264
Reply To: how to list index corresponding to statistics using select statement

p.s. You might want to check out the OBJECT_NAME(object_id [, database_id]) and OBJECT_SCHEMA_NAME(object_id [, database_id]) functions. They can greatly reduce the number of joins you have to do for things...
--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)

September 20, 2019 at 2:23 am

#3681663
Reply To: how to list index corresponding to statistics using select statement

If there is an index behind the stats, then stats_id is the same thing as the index_id in sys.indexes. Do an outer join to sys.stats from sys.indexes to make 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)

September 20, 2019 at 2:10 am

#3681661
Reply To: Drop and create a clustered index

Looks like the OP has left the building.
--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)

September 20, 2019 at 1:50 am

#3681654
Reply To: Removing a corrupted filegroup

So were you able to remove the file group after 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)

September 18, 2019 at 2:47 pm

#3681114
Reply To: Drop and create a clustered index

I'll echo ZZartin's questions and ask one more... how big is this clustered index in rows, columns, and GB occupied?
--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)

September 18, 2019 at 2:23 pm

#3681096
Reply To: Dynamically Automate SQL database restore script

To be honest, you should already have a script that does this because you should be testing your backups on a regular basis.
There are a lot of scripts out there...
--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)

September 18, 2019 at 1:22 pm

#3681076
Reply To: bulk insert headache

MVDBA (Mike Vessey) wrote:
Jeff Moden wrote:
Bulk Insert uses the privs of the login using it. You have to make sure the login being used as the privs in the source directory.
Hehe - until...
--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)

September 18, 2019 at 1:01 pm

#3681055
Reply To: The Scientific Method: a call to action

hjp wrote:
Jeff Moden wrote:
hjp wrote:
You can never prove something true!
Now there's an interesting hypothesis... I wonder how one would prove that. 😀
Along the same lines as "a car can't fly". 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)

September 18, 2019 at 12:55 pm

#3681048
Reply To: The Scientific Method: a call to action

hjp wrote:
You can never prove something true!
Now there's an interesting hypothesis... I wonder how one would prove that. 😀
I do get the spirit of that statement, though.
--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)

September 18, 2019 at 4:35 am

#3680934
Reply To: bulk insert headache

fizzleme wrote:
I have tried mapped drives and the full unc path. Life continues to be unkind. I am considering trying BCP after my root canal without nova Caine.
Bulk Insert uses...
--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)

September 18, 2019 at 3:56 am

#3680930

Viewing 15 posts - 8,626 through 8,640 (of 59,091 total)