Viewing 15 posts - 5,401 through 5,415 (of 7,191 total)
No SQL Server error message appears to have been passed through. Is there anything in the errorlog of your SQL Server from the same time? If not, I...
April 28, 2011 at 7:46 am
Unfortunately there is no such thing as a clear solution. You need to do your own research based on your own circumstances. Noel has provided a place to...
April 28, 2011 at 7:41 am
But the answer to your question is because you have built your INSERT statement but haven't executed it.
By the way, if you must use dynamic SQL, I recommend that you...
April 28, 2011 at 7:34 am
If you move the clustered indexes as well, that's the same as moving the data (assuming that all tables have a clustered index). You would be left with just...
April 28, 2011 at 7:27 am
You should be able to do all of those things. We manage our 64-bit servers from our 32-bit desktops.
John
April 28, 2011 at 7:02 am
64-bit, I'd say. I can't think of any reason to want to run a 32-bit application on a 64-bit operating system.
John
April 28, 2011 at 6:46 am
Please make sure you post in the correct forum to avoid misunderstandings like this.
You need to use DBCC SHOWCONTIG to get fragmentation information, and DBCC DBREINDEX to rebuild your indexes....
April 28, 2011 at 5:56 am
minu88 (4/28/2011)
I was having the...
April 28, 2011 at 4:48 am
Valla
If you are using SQL Server 2005, you should use dm_db_index_Physical_stats to determine fragmentation and ALTER INDEX to rebuild or reorganise, since the DBCC commands are deprecated. The most...
April 28, 2011 at 4:42 am
Marcos
You may wish to try inserting those rows in smaller batches. If your clustered index is not on an ascending key, then inserts will take longer because page splits...
April 27, 2011 at 8:25 am
marcosjroig (4/27/2011)
I deleted the primary key and I dont have a unique key. I do a control before insert to check repetitive data. Primary key has asociated clustered index,...
April 27, 2011 at 7:59 am
I'm sure if you look in Books Online you'll find what you're looking for. As far as I know, you can't specify that the trigger only fire if a...
April 27, 2011 at 7:43 am
Marcos
Why would you shrink the database if it is constantly growing? This will only lead to physical fragmentation and wasted resources when it (inevitably) grows again. I would...
April 27, 2011 at 7:35 am
Viewing 15 posts - 5,401 through 5,415 (of 7,191 total)