Viewing 15 posts - 8,251 through 8,265 (of 49,552 total)
You were running in serialisable isolation?
Did you check the session_id in the trace? Was it from the session you were testing with?
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, 2014 at 11:00 am
Not something I've tried recently, bu why not
INSERT INTO...
EXECUTE msdb.dbo.sp_help AT <linked server>
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, 2014 at 9:30 am
lallu_jaya (8/5/2014)
As master database is so imporatant, it has paths to all the files, logins,linked servers...
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, 2014 at 9:27 am
Try recreating the NC index with Partition as the third key 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 5, 2014 at 8:57 am
Was the table you were querying in master? If not, why are you checking the catalog views in master?
No, it's not a composite ID. It's either the partition id, allocation...
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, 2014 at 8:27 am
You miss some corruptions. Physical only is designed as a limited set of checks for frequent checks of busy servers. Since you're offloading the checks to another server, there's no...
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, 2014 at 8:25 am
Delete data?
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, 2014 at 8:23 am
Why are you using physical only?
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, 2014 at 8:04 am
What's 73-461? The beta 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
August 5, 2014 at 7:52 am
marcocrocevia (8/5/2014)
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, 2014 at 7:32 am
What's the definition of the table?
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, 2014 at 6:30 am
That's the easy part, and the last part. You need to get all the stuff around storing their last few selections done and working 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 5, 2014 at 6:20 am
Junglee_George (8/5/2014)
The business is very specific not to use SP or temp table in the query for the report generation.
Why? What reason do they have for such a strange requirement?
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, 2014 at 5:16 am
I don't, and I'm way too busy to write the whole thing, unless you want to wait until October.
Have a go at it, I've given you the main elements. If...
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, 2014 at 5:15 am
First thing you'll need a table that stores the user's last selection. Each user should have one row per drop down you want to do this to. When they select...
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, 2014 at 5:02 am
Viewing 15 posts - 8,251 through 8,265 (of 49,552 total)