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...
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...
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...
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 &...
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...
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/
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...
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
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...??
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,...
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...
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,...
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...
April 25, 2013 at 10:55 am
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
?
April 25, 2013 at 10:36 am
Viewing 15 posts - 13,321 through 13,335 (of 49,552 total)