Viewing 15 posts - 1 through 15 (of 38 total)
You can use an XML configuration file to be read at runtime.
So all you would have to do is change the configuration file to point to a different database.
The initial...
November 3, 2011 at 1:33 pm
Is the GUID your clustered index key as well?
If so you are probably seeing lots of page splits when you are doing inserts.
Best way of speeding that up would be...
November 3, 2011 at 11:56 am
Bulk Insert will almost always be the fastest way to tranfer large amounts of data.
Best way is to create a SSIS package to transfer the data and schedule a job...
October 17, 2011 at 6:32 pm
As others have mentioned adding more memory can mask inefficient queries that you won't notice until the server starts using more memory.
When you look at an inefficient query, it may...
October 10, 2011 at 12:00 pm
Or just take time to learn the features of native SQL backup first before going into any third party route. SQL 2008 improved upon the older version with compression...
September 29, 2011 at 6:21 pm
Or just wait until Denali releases which should be sometimes next year.
July 28, 2011 at 4:33 pm
It's reserved to follow ANSI SQL-99 standard as a keyword.
July 27, 2011 at 4:53 pm
Number two should be the simplest way to a clean install.
I don't see any issue with restoring 2005 sql backup on sql 2008 r2.
We are expecting to do the same...
July 26, 2011 at 6:10 pm
You can create a CLR function to compress and decompress the data and call the function to store and retrieve data.
July 22, 2011 at 4:53 pm
Two really useful tool for detecting blocking is sp_whoisactive and server side trace with blocked process report. Latter will allow you to actively monitor and log blocking info and...
July 20, 2011 at 11:38 am
Did you look in the data and log directory to see if the data and log files are there?
June 14, 2011 at 1:26 am
That query would run the fastest if there was a nonclustered index on MyColumn.
Otherwise it would have to scan through the entire clustered index to get the count and it...
June 13, 2011 at 5:44 pm
why don't you do the insert within a stored procedure and you can do all the logic within the proc?
I don't believe there is any way of doing what you...
June 13, 2011 at 12:20 pm
Grant Fritchey (6/13/2011)
In addition to videos which can be incomplete, I'd suggest getting a copy of Kalen Delaney's book "SQL Server 2008 Internals." It's a must own.
I second this.
It will...
June 13, 2011 at 11:37 am
You want SQL Server to index the contents of your file?
What type of file are you going to store?
June 11, 2011 at 10:01 am
Viewing 15 posts - 1 through 15 (of 38 total)