Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,711 through 22,725 (of 59,067 total)

RE: Importance of RAM for SQL Server 2008 (does bus speed matter?)

ScottPletcher (9/18/2014)
CPU is typically not the bottleneck nowadays, I/O is. More RAM = bigger buffers = less I/O. Thus, RAM will typically be much more vital to performance...
--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, 2014 at 3:52 pm

#1746557
RE: CPU speed, cache size, latency of caches

Maintainer (9/17/2014)
For processors, I want good CPUs with fast, small caches? A large cache on each processor probably wouldn't help.
64 GB of RAM seems like way more...
--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, 2014 at 2:53 pm

#1746547
RE: Are the posted questions getting worse?

Grant Fritchey (9/17/2014)
Jack Corbett (9/17/2014)
Grant Fritchey (9/17/2014)
So this is happening[/url]. If any of the Threadizens are inclined to make a blog post (or three) in support, I'd 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)

September 18, 2014 at 6:00 am

#1746352
RE: Export to CSV and email

Frank Cazabon (9/17/2014)
Hi,
I need to have a process extract some data, export it to CSV and then send it as a plain (non-MIME) message, or as a single-part MIME message....
--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 17, 2014 at 8:44 pm

#1746262
RE: Merging Non overlapping timedates

Perhaps I'm missing something but for each job, wouldn't you just compare the start date of the job with the end date of the other jobs and the end date...
--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 17, 2014 at 8:31 pm

#1746260
RE: rename a reporting server

Not sure about your final question on the naming but make sure that you change the IP address of the new server to that of the old server, as well....
--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 17, 2014 at 8:07 pm

#1746257
RE: Week Start and End by Month

Thanks, Mark,
DATEDIFF is the tough one for most folks because they frequently don't understand that it works on the BOUNDARIES of the datepart. For example, a DATEDIFF(yy,'2014-12-31 23:59:59.997','2015-01-01 00:00:00.000')...
--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 17, 2014 at 8:02 pm

#1746256
RE: CPU speed, cache size, latency of caches

Heh... I don't know what "normal" is anymore when it comes to things like this. With that in mind...
If it's a new box that will be built, start with...
--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 17, 2014 at 7:52 pm

#1746255
RE: Frequent Index Fragmentation

Maintainer (9/17/2014)
I would try 10% as a guideline. But that may not be appropriate for your situation.
Just to be clear to the OP... that's not the FILL FACTOR... that's...
--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 17, 2014 at 7:29 pm

#1746252
RE: Release a large amount of free space from a data file.

So let me know about the size of the 3 or 4 largest tables and their indexes. We might be able to pull off a small miracle.
--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 17, 2014 at 7:24 pm

#1746250
RE: Are the posted questions getting worse?

SQLRNNR (9/17/2014)
Ahhh but SQL 2014 does come with a turbo button.:w00t:
BWAAA-HAAAAA!!!!! SQL Server has always had that "button". Just set "Boost SQL Server Priority" setting to "ON" so 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 17, 2014 at 7:12 pm

#1746247
RE: Are the posted questions getting worse?

Roy Ernest (9/17/2014)
I advised the OP to go for Set based. I hope he does not think that SQL 2014 will magically get everything to run faster.
Oddly enough, I...
--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 17, 2014 at 7:07 pm

#1746246
RE: Release a large amount of free space from a data file.

Welsh Corgi (9/17/2014)
I'm not concerned that it may grow at the same rate.
I am concerned that it happened.
I want to re-index and I thought that it would not hurt to...
--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 17, 2014 at 7:04 pm

#1746244
RE: Release a large amount of free space from a data file.

Welsh Corgi (9/17/2014)
I have a Database that is currently 642 GB is size with 317 GB free (49%).
I do not know how it got so large but what would 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)

September 17, 2014 at 7:00 pm

#1746243
RE: Are the posted questions getting worse?

Roy Ernest (9/17/2014)
I got someone asking if Cursor will work fast on memory based objects.
It felt like the OP would upgrade to SQL 2014 so that he/she can make...
--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 17, 2014 at 6:53 pm

#1746240

Viewing 15 posts - 22,711 through 22,725 (of 59,067 total)