Viewing 15 posts - 2,686 through 2,700 (of 49,552 total)
BLOB_EATER (8/5/2016)
when you select a topic to talk about is it something that you know absolutely 100% everything about?
No one knows absolutely 100% about a topic.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2016 at 6:13 am
Grant Fritchey (8/4/2016)
Phil Parkin (8/4/2016)
SSIS can run procs in parallel, no problem.Or threading through PowerShell.
Or async and parallel via Service Broker, if you're feeling very brave.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2016 at 7:32 am
GilaMonster (8/1/2016)
A rebuild of a 10GB index will require more than 10GB of log space.
Because there's other log records involved, and any other concurrent activities, and log reservations, and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2016 at 6:01 am
No database can be restored down-version, Plus, for master, I generally recommend not restoring from one server to a different one, as there can be problems resulting from doing so.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2016 at 2:47 am
The entire new index gets logged. The space does get released once the rebuild finishes, into the log file for reuse (because if that much space was required once, it'll...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 3, 2016 at 5:13 am
No it doesn't.
Lookups are the number of key lookups done to that index, and it will only every be >0 on clustered indexes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 2, 2016 at 1:43 pm
Grant Fritchey (8/2/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 2, 2016 at 9:49 am
BLOB_EATER (8/2/2016)
Do you guys have any advice on how to improve my stats for my blog?
Keep writing regular, good material, and stop looking at the stats.
I think the first...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 2, 2016 at 9:47 am
Query sys.dm_exec_requests, join to sys._dm_exec_connections and cross apply to sys.dm_exec_sql_text using the sql_handle column.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 2, 2016 at 9:03 am
Perry Whittle (8/2/2016)
GilaMonster (8/2/2016)
That's the account for machinename\local system, used if you have services running on that machine running as local system (which is not a good thing to do)
It's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 2, 2016 at 9:01 am
pcd_au (8/2/2016)
Frankly if the query is going to take 3 minutes to run and 4 nano seconds to compile who cares about the compilation.
In that case, indeed, who cares (though...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 2, 2016 at 8:56 am
krypto69 (8/2/2016)
Without the TF 1117 the splitting of the tempdb into multiple files is likely to be an utterly useless exercise as the load will more or less end up...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 2, 2016 at 8:42 am
tariq (8/1/2016)
Can user login to SQL Server using machine name instead of user login ID?
No. You need a login name and password, or a valid windows authentication token for a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 2, 2016 at 12:35 am
Jeff Moden (8/1/2016)
Eirikur Eiriksson (8/1/2016)
Quick question, have you set the TFs 1117 & 1118?😎
Setting TF1118 is cool but setting TF1117 comes with some serious problems if you have partitioned tables...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 2, 2016 at 12:06 am
krypto69 (8/1/2016)
As part of that server we now have the power/space to split out our Tempdb from one file to 12.
Why?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 1, 2016 at 10:21 am
Viewing 15 posts - 2,686 through 2,700 (of 49,552 total)