You have noticed that this thread is from 2006, haven't you?
Welcome to the forums! Instead of posting your query, it would have been more beneficial if you've posted a description of your problem, your table...
I think you're looking for DBCC SHRINKFILE with the EMPTYFILE option to migrate data to a different file in the same filegroup. If so, I would only...
Hm, hard to tell, if it is now failing on the same line of code as before. You might be able to test this by wrapping the whole SELECT ...INTO......
Please don't multi-post!
Looks like the same error as in your "reindex" thread. See, if the same solution helps here as well.
Nothings' wrong with your original variable declaration. Object names in SQL Server all follow the restrictions for Database Identifiers. As far as I...
I might be wrong, but views are "virtual tables" that usually only materialise when queried. So when you export data from a view's result set, it...
Okay, understood. But still the next reindex will reclaim the space and the file will grow again. You may want to read carefully through this one....
Why do you want to reduce the size of the file at all? I guess next time you reindex it'll grow again and that this will lead to a yo-yo effect and...
Welcome to the forum! Sorry, maybe I've missed something, but this company is willing to give you their database when you have a script that changes...
Duplicate. Please continue here: http://www.sql-server-performance.com/forum/threads/generate-serie-with-memory.34038/
Welcome to the forum! Your reference b.col3 in the WHERE clause is turning the LEFT JOIN effectively into an INNER JOIN. It might be better to move...
Welcome to the forum! I think you have to get some more explanation about the purpose of your exercise. How can you compare performance differences...
If there is no particular order in which the scripts have to be executed, then it should be quite easy to build a batch file using FORFILES to call...
Welcome to the forums! What have you tried so far? Apart from posting this question in multiple communities?
Are you that new to online communities and basic netiquette or do you really think such a subject and now this reply will get you any problem-related...
Finding a good provider one is happy with 100% is tough and unfortunately one only finds out in situations like this what a provider is really worth....
Unless I am missing something, you can achieve this by adding an ORDER BY Time, EventTypeID to your query.
The code is pretty identical, however have you compared the execution plans if they are as well? Take your time to read through this white-paper, if...
Separate names with a comma.
