Viewing 15 posts - 16,306 through 16,320 (of 49,552 total)
Paul Clark-418949 (10/3/2012)
Can't a Detach/Attach also cause orphaned SQL users? .
Not if detaching and attaching to the same instance.
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
October 3, 2012 at 7:04 am
It may not be that much impact. Depends on how long transactions are.
Anyway, read committed snapshot has the lower tempDB impact, snapshot isolation is usually more impact.
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
October 3, 2012 at 6:51 am
Zeal-DBA (10/3/2012)
suppose i am using select queries like this frequently
select * from T where id =6
select * from T where ch ='!'
select * from T where na ='sue'
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
October 3, 2012 at 6:41 am
PiMané (10/3/2012)
If the 1st 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
October 3, 2012 at 6:41 am
On SQL Server 2008 you don't need a trace and you don't event need the traceflag. Deadlock graphs are written automatically to the system health extended events session.
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
October 3, 2012 at 6:37 am
HowardW (10/2/2012)
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
October 3, 2012 at 6:35 am
And a script without any GO is a single batch, no matter how long it is.
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
October 3, 2012 at 6:33 am
No. http://msdn.microsoft.com/en-us/library/ee343986%28v=sql.100%29.aspx
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
October 3, 2012 at 6:31 am
A query is a single select, insert, update or delete (or related) statements. A batch is a set of one or more statements that are submitted to the server as...
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
October 3, 2012 at 3:52 am
Compiled = plan generated by the optimiser. So that's the number of times that the procedure has been executed since the current execution plan was compiled by the optimiser.
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
October 3, 2012 at 3:50 am
Primary data file, secondary data file for mdf and ndf if it's important. Ldf is the log file, no D, probably just there to keep the pattern
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
October 3, 2012 at 3:21 am
Batch - current batch of SQL statements (set of statements sent to the server) http://msdn.microsoft.com/en-us/library/ms175502%28v=sql.105%29.aspx
Persisted object - stored procedure, function or trigger.
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
October 3, 2012 at 2:05 am
Alexander-449406 (10/2/2012)
SELECT
TOP 1 s.SiteID
FROM
Sites s
INNER JOIN SiteUrls su
ON su.SiteID = s.SiteID
WHERE
@Url like su.URL...
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
October 3, 2012 at 2:04 am
I am going to suggest MSDN, because it is a good resource. All the DMVs are well documented there. Start with sys.dm_exec_cached_plans and have a look at all related DMVs.
Again,...
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
October 3, 2012 at 1:30 am
It doesn't mean much, it's just used to join several of the plan-related DMVs together.
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
October 3, 2012 at 1:22 am
Viewing 15 posts - 16,306 through 16,320 (of 49,552 total)