Viewing 15 posts - 1,531 through 1,545 (of 3,232 total)
Good article. It was helpful to know about the allocation units. I am in the process of designing a data mart type application DB where we'll be storing...
January 7, 2009 at 9:24 am
If you are wanting to get some measurements on baseline IO throughput on your SAN, you may want to look into using some third party tools to help with that...
December 12, 2008 at 2:01 pm
I don't see anything alarming here. All of the values are within acceptable ranges. The CPU usage seems a bit high for just one process, but it is...
December 12, 2008 at 1:41 pm
The timeout itself is usually issued by the calling application. If it is using ADO, there are 2 timeout parameters that can be configured to lengthen the amount of...
December 12, 2008 at 1:27 pm
Well, it is normal for resource usage to increase as new jobs/requests are being processed by the server. This could be bad of course depending on the size and...
December 12, 2008 at 1:00 pm
Good, just checking. You never know, without asking, if someone is wanting to attempt to modify the system tables directly or not.
November 21, 2008 at 2:34 pm
The data relevant to exploring SQL Server partitioning functions/schemes are spread throughout a number of views. You'll want to look at sys.partition_range_values, sys.partition_functions, sys.partitions, among possibly others. Use...
November 21, 2008 at 2:26 pm
Keep in mind that you do not have to change your recovery mode to bulk-logged to use bcp. It is still faster than using INSERT INTO even when in...
November 20, 2008 at 10:07 am
I'd be curious to see how that runs on a large table > 1M rows. I don't have the time to test it myself, but I'd be curious. ...
November 20, 2008 at 9:59 am
Here's a way to do it without the CTE.
DECLARE @Calls TABLE (AccountNumber int, TelephoneNumber varchar(10), DateCalled datetime)
INSERT INTO @Calls
SELECT 1, 4026146434, '2008-11-17 17:01:27.023' UNION ALL
SELECT 2, 4026115201, '2008-11-19 17:01:27.023'...
November 19, 2008 at 4:07 pm
You don't want to copy the MDF file if you are only looking to move one table over. Use bcp.
November 19, 2008 at 3:53 pm
In that case, use LEN:
DECLARE @Table TABLE (Col1 int, Col2 varchar(50))
INSERT INTO @Table
SELECT 1, '123234345' UNION ALL
SELECT 2, '123456789124578'
SELECT *
FROM @Table
WHERE LEN(Col2) < 12
November 7, 2008 at 11:16 am
When you say text, do you really mean a text datatype or is it a varchar/char data type?
November 7, 2008 at 10:56 am
MrBaseball34 (11/3/2008)
what do you mean here:
SELECT .......... UNION ALL
SELECT .......... UNION ALL
SELECT ...........
I don't know what to put as the ...........
I'm asking for you to take the effort in creating...
November 3, 2008 at 3:28 pm
Right. Just put together a combination of handful of the rows that worked and a handful of rows that the update missed.
November 3, 2008 at 2:15 pm
Viewing 15 posts - 1,531 through 1,545 (of 3,232 total)