Viewing 15 posts - 10,921 through 10,935 (of 49,552 total)
PearlJammer1 (11/15/2013)
Am i right in answering your question as the first login that takes 50ms - As this will be present in the dmvs because it doesn't disconnect.
The one that...
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
November 15, 2013 at 5:52 am
First question, is that nonclustered index useful? Are the queries in the procedure using it or is it a waste of space?
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
November 15, 2013 at 4:38 am
The CPU values that the DMVs return for sessions is ms of CPU time since login time. Hence sessions that have been connected for a long time (as replication jobs...
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
November 15, 2013 at 4:23 am
No, you don't need to be working for anyone in particular, or even to be working at all. Anyone can register, pay for and write an exam.
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
November 15, 2013 at 3:35 am
You'd need to look at the query that the report is running. The DMV shows null if an index hasn't been used, so the dates you see come from the...
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
November 15, 2013 at 3:34 am
You can create a SQL Agent alert on the appropriate error message. You'll still have the effects of a full log on the DB though.
Why is your log filling often...
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
November 15, 2013 at 2:29 am
If you want to remove the nulls in the table
UPDATE <table name> SET <column name> = 0 WHERE <column name> IS NULL -- (a float cannot contain the string value...
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
November 15, 2013 at 1:33 am
shew (11/14/2013)
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
November 14, 2013 at 12:15 pm
Post them. Won't have a chance tonight. Maybe tomorrow, maybe saturday.
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
November 14, 2013 at 11:50 am
Ah, see what you mean.
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
November 14, 2013 at 11:49 am
Identities have never been gap-less. Why is having no gaps in what is probably an artificial primary key (column without meaning) important?
If no gaps is a requirement, you can't use...
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
November 14, 2013 at 11:44 am
Next time the query misbehaves, can you capture the actual execution plan (not estimated please) before and after the index rebuild? Without that, just guessing.
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
November 14, 2013 at 11:34 am
LutzM (11/14/2013)
It might be driven by the developer who want to make sure the key is unique but wasn't able to define a UNIQUE PRIMARY KEY (for...
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
November 14, 2013 at 11:22 am
Or stale stats on the same table, on a different column. Or on another table. Or a bad plan (from bad parameter sniffing) getting into cache maybe.
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
November 14, 2013 at 11:20 am
crmitchell (11/14/2013)
Could this have happened following a reboot of the Windows box hosting SQL Server?
Only if, after the reboot, someone ran ALTER DATABASE <db name> SET OFFLINE.
SQL will not set...
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
November 14, 2013 at 9:54 am
Viewing 15 posts - 10,921 through 10,935 (of 49,552 total)