Viewing 15 posts - 13,321 through 13,335 (of 49,552 total)
That's not going to do what you want, if I understand your requirements. If I log in to SQL once, log out then log in a second time later 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
April 29, 2013 at 3:08 am
IgorMi (4/28/2013)
If your index is clustered, then after disabling it, your data will be read only and you must rebuild it for update operations.
Disabling a clustered index prevents all access...
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
April 28, 2013 at 7:00 am
Could you be a bit more specific about what you're trying to do and why?
If you mean query execution, there's hints to force specific indexes but no hint to ignore...
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
April 28, 2013 at 6:58 am
It is effectively dropped, you can't in any way access the table variable after it goes out of scope. As an optimisation, SQL caches the definitions for temp tables &...
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
April 28, 2013 at 6:56 am
1) DBCC DBREINDEX is deprecated, is included only for backward compatibility with SQL Server 2000 and should not be used any longer
2) Up to you. Depends on your requirements and...
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
April 28, 2013 at 6:53 am
Have a read through chapter 3 of http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
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
April 25, 2013 at 1:40 pm
Lynn Pettis (4/25/2013)
GilaMonster (4/25/2013)
No, it was aimed at me. The "previous comment" was when he called me a pedant for asking for more information. http://www.sqlservercentral.com/Forums/Topic1446457-392-1.aspx
No, I agree that he was...
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
April 25, 2013 at 1:20 pm
No, it was aimed at me. The "previous comment" was when he called me a pedant for asking for more information. http://www.sqlservercentral.com/Forums/Topic1446457-392-1.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
April 25, 2013 at 12:40 pm
Really? http://www.sqlservercentral.com/Forums/FindPost1446662.aspx
I get called out for not answering, I get called out for answering. What 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
April 25, 2013 at 12:19 pm
SQL_Enthusiast (4/25/2013)
Let's say, for whatever crazy reason, that temp tables are not an option. Is there a problem with using VIEWS?
Maybe. Maybe not. Depends on what's in the views,...
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
April 25, 2013 at 11:30 am
ScottPletcher (4/25/2013)
GilaMonster (4/25/2013)
Abu Dina (4/25/2013)
I bet it's the table variables. They can't have indexes on them nor stats maintained for the data.
Table variables don't have stats, but they certainly can...
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
April 25, 2013 at 11:28 am
Abu Dina (4/25/2013)
I bet it's the table variables. They can't have indexes on them nor stats maintained for the data.
Table variables don't have stats, but they certainly can have 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
April 25, 2013 at 10:55 am
Very likely because of the table variables. They don't have stats and hence (without a recompile) the optimiser will always estimate one row. It there's actually lots of rows, 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
April 25, 2013 at 10:55 am
Please read through this - Managing Transaction Logs[/url]
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
April 25, 2013 at 10:51 am
Abu Dina (4/25/2013)
Gila, you're such a pedant!
a person who is excessively concerned with minor details and rules or with displaying academic learning
?
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
April 25, 2013 at 10:36 am
Viewing 15 posts - 13,321 through 13,335 (of 49,552 total)