Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,886 through 18,900 (of 59,098 total)

RE: Data

Eirikur Eiriksson (12/22/2015)
Quick thought, you could possibly remove the spaces in both columns for the comparison, not going to be too efficient though.
... unless you add persisted computed columns...
--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 22, 2015 at 3:37 pm

#1847604
RE: SQL server slowdown by increasing processors?

You can find out if that's the actual problem. Add OPTION(MAXDOP 1) to the reporting queries to limit to 1 CPU and see what happens.
--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 22, 2015 at 3:04 pm

#1847599
RE: Is it truly important to clean up connections in a "sleeping" state?

Unless there's an actual "connection leak" (extremely rare), there's usually nothing to worry about especially when there's connection pooling. If you do have a "connection leak", you won't have...
--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 22, 2015 at 2:48 pm

#1847596
RE: CLR Yes or no?

mishka-723908 (12/22/2015)
Hello,
We have a Warehouse DB server. The main DB is the Warehouse and there are a few auxiliary databases on the server as well. I have a developer who...
--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 22, 2015 at 2:45 pm

#1847593
RE: Packaged-Application Database Nightmares - A Horror Story.

From the article:
This horror story is fictionalized...
Heh... no it's not. It almost perfectly describes what I've been through twice and am still trying to pick up the pieces. 😛
--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 22, 2015 at 9:35 am

#1847487
RE: Calculating a Year Number and Sequence number using a date field

Charlottecb (12/22/2015)
Regards your concern about using the value for any real use, it is only a friendly number used for the contractors so it doesn't matter too much.
If that's true,...
--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 22, 2015 at 9:10 am

#1847477
RE: Please Suggest Partition boundaries

TheSQLGuru (12/22/2015)
Partitioning CAN make PROPERLY DESIGNED report queries go much faster when partition elimination can allow said queries to hit a small fraction of the total data. There is no...
--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 22, 2015 at 9:03 am

#1847470
RE: Partitioned index on partitioned table

ScottPletcher (12/21/2015)
If you (almost) always look up by PartitionID and Name, then the table should be clustered first on those columns. If you really want/need to, add other columns...
--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 21, 2015 at 10:34 pm

#1847336
RE: Efficient way to gat all unique values and their counts for a dynamic list of fields using one query statement

Something like this is pretty easy if you know about a personal friend of mine... the SQL_Variant datatype. It can be a bit of a fair weather friend so...
--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 21, 2015 at 10:20 pm

#1847334
RE: Cumulative Updates and Security Patches

hiram.osiris (12/21/2015)
Hello Folks
I have a requirement to apply the latest patches to our SQL Server environments, from SQL Server 2000 to SQL Server 2014. I have a doubt regarding SQL...
--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 21, 2015 at 8:19 pm

#1847325
RE: Duplicate Nonclustered Index

To answer your second question first, someone probably just made a mistake.
To answer your first question, if you have a unique non-clustered and a non-unique non-clustered index on exactly 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 21, 2015 at 8:15 pm

#1847324
RE: How to reduce Huge Log File size

WhiteLotus (12/21/2015)
I haven't changed the autogrow option yet , it is still in 10% growth position.
I am thinking to change it to 512 MB . What do you think ?...
--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 21, 2015 at 8:11 pm

#1847323
RE: DBA Tasks - To automate or use my own eyes

Oh, and getting back to the title question of this post of "DBA Tasks - To automate or use my own eyes", the only correct answer is both. Automation...
--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 21, 2015 at 8:03 pm

#1847322
RE: Using SELECT as 'IN' predicate condition for PIVOT

matt.warren 33350 (12/21/2015)
Hello Luis,
I can't thank you enough for all your help.
I ran into some errors with the code you helped me with, but having seen your advice, it makes...
--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 21, 2015 at 7:47 pm

#1847320
RE: Another Recursive Hierarchy bit of help needed...

Jason A. Long (12/21/2015)
Jeff will no doubt follow up with something super cool...
Not so much as the hierarchical query goes. You pretty much topped that off quite nicely....
--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 21, 2015 at 7:21 pm

#1847316

Viewing 15 posts - 18,886 through 18,900 (of 59,098 total)