Viewing 15 posts - 11,686 through 11,700 (of 49,552 total)
Most, if not all of that you should be able to get from sys.dm_exec_sessions, sys.dm_exec_requests and/or sys.dm_os_waiting_tasks.
Have a go through those DMVs, if you can't get something as you want...
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
September 16, 2013 at 7:07 am
wendy elizabeth (9/15/2013)
How do you create an indexed view?
Why are you thinking about creating an indexed view?
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
September 16, 2013 at 6:43 am
jasona.work (9/16/2013)
Koen Verbeeck (9/16/2013)
jasona.work (9/16/2013)
(ducks behind fresh built snow fort. And people *LAUGHED* when I bought a snow making machine!)I bet they are still laughing...
😀
Right up until I aim...
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
September 16, 2013 at 6:42 am
What is the exact command you're using to back up the log?
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
September 16, 2013 at 6:39 am
If you were getting an error saying that nulls are not allowed, then there were nulls in the select for that column.
Post the exact code, we can't tell what's wrong...
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
September 16, 2013 at 3:27 am
Maybe start by reading the whitepaper linked here: http://sqlblog.com/blogs/kalen_delaney/archive/2013/06/05/hekaton-whitepaper.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
September 16, 2013 at 2:43 am
You've got a small row count, so differences in time probably won't be noticable and if you look at the examples in the blog posts, you'll see that mostly 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
September 15, 2013 at 4:45 pm
Please post table definition, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
September 15, 2013 at 2:15 pm
You can query the sys.columns metadata view to see what tables have particular columns in them.
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
September 15, 2013 at 5:45 am
Not physical IOs, just IO usage. More IO usage, more chance that some will be physical. If you're tuning IO, tune logical IOs, if less data is needed overall, less...
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
September 15, 2013 at 5:44 am
You don't need a case statement here.
Take the query you posted, figure out how to have that query only return salary values that match the 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
September 15, 2013 at 5:41 am
Please run the following and post the full and complete, unedited output
DBCC CheckDB (<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
You can also point out to the vendor who recommended that, that rebuilding...
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
September 15, 2013 at 5:40 am
If you need a particular order by on a set of rows, then you need an order by statement on the outer-most select. This isn't about order of subqueries executed,...
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
September 15, 2013 at 5:36 am
First things first, take that query you already have and figure out how to have it only return rows for salary under a specific value (which from the reading I...
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
September 14, 2013 at 10:19 am
I'm not going to do your homework for you. You learn nothing, I don't need the practice and I'm sure your lecturer doesn't condone other people doing your work 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
September 14, 2013 at 8:24 am
Viewing 15 posts - 11,686 through 11,700 (of 49,552 total)