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...
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.
February 25, 2013 at 3:34 am
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...
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.
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...
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...
February 24, 2013 at 7:33 am
Anuj Rathi (2/23/2013)
Which one is efficient?
Test them both and see?
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.
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...
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...
February 23, 2013 at 10:33 am
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...
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/
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...
February 23, 2013 at 8:23 am
Viewing 15 posts - 14,161 through 14,175 (of 49,552 total)