Viewing 15 posts - 14,161 through 14,175 (of 49,552 total)
munnaonly (2/25/2013)
Can you please help on this, if any thing...
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
February 25, 2013 at 4:54 am
Unless you have some custom auditing implemented to record database property changes, there won't be a record.
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
February 25, 2013 at 3:34 am
https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
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
February 25, 2013 at 2:41 am
You don't need to reset TempDB, you need to tune the query so that it doesn't need so much TempDB space or drop the temp objects that you're using between...
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
February 25, 2013 at 2:18 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Pictures of the plan are pretty useless.
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
February 25, 2013 at 1:56 am
You're not filtering by AdID. If you were, that would be SARGable. You're filtering by a function on AdID, and that, like all other functions, is not SARGable, hence 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
February 24, 2013 at 10:07 am
Well the row number can't be a seek predicate, because there's no index on the row_number.
As for the other columns, incorrect index order?
http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/
Also there's a chapter in Pro SQL 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
February 24, 2013 at 7:33 am
Anuj Rathi (2/23/2013)
Which one is efficient?
Test them both and see?
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
February 24, 2013 at 3:38 am
AndrewSQLDBA (2/23/2013)
... and change the owner to a different schema.
There's a very big difference between owner and schema, don't confuse 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
February 23, 2013 at 11:22 am
- Win (2/23/2013)
Hope it helps...--- Executable scripts to change table owner
SELECT 'EXEC sp_changeobjectowner '''+ SCHEMA_NAME(schema_id) + '.' + OBJECT_NAME(object_Id) + ''', ''dbo'''FROM sys.tables
This stored procedure only works with the objects...
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
February 23, 2013 at 10:34 am
AndrewSQLDBA (2/23/2013)
I would like the change the owner of all tables in a database from 'dbo' to 'Test'.
Do you want to change the owner of the table or do you...
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
February 23, 2013 at 10:33 am
http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=29
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
February 23, 2013 at 10:31 am
The error is because you restored a log backup WITH RECOVERY.
Besides, that's the wrong order. Restore full, the last diff and then the log backups to reach the point...
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
February 23, 2013 at 10:29 am
Please post table definitions, 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
February 23, 2013 at 10:28 am
It's a violation of the NDA for anyone who has written the exam to discuss the contents or questions. As such, at best you'll get very vague answers. Also bear...
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
February 23, 2013 at 8:23 am
Viewing 15 posts - 14,161 through 14,175 (of 49,552 total)