Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,856 through 18,870 (of 59,072 total)

RE: CLR Yes or no?

That might be a decent use but it really depends on how the CLR is written. My suggestion would be to test it for performance in a Dev environment...
--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 6:01 pm

#1847625
RE: How to reduce Huge Log File size

WhiteLotus (12/21/2015)
Sounds good ..I also notice that all databases autogrowth option are 10% . Should I change all of them ?
If the initial size was 1MB, it takes 73 growths...
--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 4:55 pm

#1847618
RE: Changing the column name dynamically

koti.raavi (12/21/2015)
Hi All,
Below is the sample query
Select Month1,Month2,Month3......Month24 from #temp
I need to display data like below
Select Month1 as [Dec 2015], Month2 as [Jan 2016],Month3 as [Feb 2016] From...
--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 4:12 pm

#1847614
RE: Many individual inserts hitting one CPU core

I know it's going to sound crazy but it sounds like a network cable, NIC, or Switch/Hub port may have gone bad. It could also be that some genius...
--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:49 pm

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

Viewing 15 posts - 18,856 through 18,870 (of 59,072 total)