Viewing 15 posts - 24,046 through 24,060 (of 49,552 total)
I'm not really in the mood for playing 20 questions here.
Again I will ask:
What values do you want for the other columns? If you want in one row the min...
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 21, 2011 at 3:16 pm
The query I gave you earlier does that.
What about the rest of the columns? Which values do you want to show with that row?
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 21, 2011 at 1:59 pm
You didn't read the article...
One more thing, taking that earlier set of data you posted
ID stardatetime enddatetime
135 10:40:25 10:40:25
135 10:40:27 10:40:27
135 10:40:27 10:41:05
Now, what do you want to see 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
August 21, 2011 at 12:09 pm
Are you going to tell me what columns are in the table, or should I guess?
Read this to see the best way to post this to get quick responses. http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 21, 2011 at 11:27 am
If I have to guess at what you want and what your table really looks like, 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 21, 2011 at 10:50 am
This works for your listed set of data, but I'm not sure it's what you really want...
SELECT ID, MIN(startdatetime) as MinStartDateTime, MAX(enddatetime) as EndDateTime
FROM SomeTable
Group By ID
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 21, 2011 at 10:11 am
From Books Online:
The affinity I/O mask option is an advanced option. If you are using the sp_configure system stored procedure to change the setting, you can change affinity I/O mask...
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 21, 2011 at 9:07 am
ALZDBA (8/21/2011)
It is a first step and IMHO a good one to work on experience with the topology and science of when and how to split data and indexes.
Depends.
There are...
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 21, 2011 at 9:04 am
When most of my queries use covering indexes
When my data is in cache already (which hopefully is most of the time)
When a query is only using the clustered indexes of...
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 21, 2011 at 6:15 am
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
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 21, 2011 at 5:02 am
Jeff Moden (8/20/2011)
Hmmm... like any table, I thought that all of the rows of a TVP had to have the same number and type of columns in the same order.
Of...
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 21, 2011 at 4:59 am
http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-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 20, 2011 at 3:29 pm
Marios Philippopoulos (8/20/2011)
Jeffrey Williams-493691 (8/20/2011)
I see this a lot, and the assumption by the person is that splitting...
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 20, 2011 at 3:26 pm
76 nonclustered indexes? First thing I'd do is remove unnecessary/redundant indexes. That's way more than should probably be on a table except in OLAP/datawarehouse.
To move the indexes you use CREATE...
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 20, 2011 at 6:39 am
Restrict their permissions. An admin can do anything and there is no way to deny an admin anything in SQL. If they're doing things they shouldn't be speak to 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
August 20, 2011 at 5:15 am
Viewing 15 posts - 24,046 through 24,060 (of 49,552 total)