Viewing 15 posts - 286 through 300 (of 411 total)
The tempdb one-data-file-per-processor-core is discussed in detail on Paul Randall's blog here: http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%281230%29-tempdb-should-always-have-one-data-file-per-processor-core.aspx. He talks about how this Microsoft recommendation is probably not the best in most cases, but...
March 28, 2011 at 4:54 pm
Also, even though tempdb is recreated each time SQL Server starts, unlike a brand new user database, the new tempdb file settings, including it's size is taken from the...
March 27, 2011 at 3:11 pm
Nice job Lowell. Very clear and organized explanation and code.
Jim
March 27, 2011 at 6:26 am
To create a proc:
CREATE PROCEDURE p_Rank
AS
WITH RankedPrices
AS
(SELECT i_serial , I_C_O, ROW_NUMBER() OVER (ORDER BY i_serial) AS rn
FROM IC_Raw_In)
SELECT a.i_serial, AVG(b.I_C_O) AS avgs
...
March 26, 2011 at 10:02 am
Yes, grant the db_backupoperator role to that login.
Jim
March 26, 2011 at 9:51 am
When you run sp_who2, one column indicates the wait time.
Jim
March 26, 2011 at 9:36 am
No drawbacks. sp_configure With no parameters, just shows you the existing settings in SQL Server and if it is active or not (Runnable column).
Passing parameters tp sp_configure changes the settings,...
March 26, 2011 at 9:12 am
A new User databases size will be the same as the Model database. To get details of the files, their locations and sizes on any database, including tempdb, you...
March 25, 2011 at 12:18 pm
Rebuilding indexes and stats does not solve all performance problems, only some parts of performance.
I think you need to start at the beginning and figure out your current bottleneck. Look...
March 25, 2011 at 12:11 pm
iPad 2? I'm jealous! A friend of mine just got the iPad 2 after selling their iPad 1. Loves it. New case sucks though - the whole device...
March 24, 2011 at 10:24 am
Oh wait, as I remember, the time I had to perform this ritual, I was on SQL 7. So disregard the r2 statement. I was working with r2 that...
March 24, 2011 at 10:03 am
Oh cool. I did about 4 or 5 log backups on 2008r2 and got nowhere, so I wrote the loop. Even with a loop, I had to fill up about...
March 24, 2011 at 9:59 am
And if you have no real activity on that database as regards data modifications, you can create a table with a char(8000) field (one page worth), then make a loop...
March 24, 2011 at 9:48 am
A port of some sort is mandatory to be open for one computer to communicate to another; that's how the network works. Therefore, the best port they can open...
March 24, 2011 at 9:37 am
I looks like you want to SELECT the min and max dates (and Name and Work), and GROUP BY the Name and Work.
Jim
March 23, 2011 at 1:40 pm
Viewing 15 posts - 286 through 300 (of 411 total)