yulichka (10/28/2008)

---

We are getting the following error when opening these databases.

Database 'master4IDR' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog...

You can start with sp_spaceused. There are also several good dmv's

check out sys.dm_db_file_space_usage and sys.database_files.

DAB

You only need to create a shell of the table, i.e. just columns and data types. What Phillip is describing is called "SWITCHING" out data. You "move" data from one...

Sorry about that, the " "got stripped.

I meant

SET column1 = REPLACE( column1, 'Jasper Conran', 'JC' )

If I read this correctly and you ONLY want to change the values of Jasper Conran to JC then you can use the REPLACE command...

SET , 'Jasper Conran', 'JC'...

I think sp_spaceused is a little more accurate. The index_size column is derived from the used_page_count, in_row_data_page_count, lob_used_page_count and row_overflow_used_page_count columns from sys.dm_db_partition_stats.

Initially, I was thrown off by the page_count...

No, it is part of the SELECT clause...

select servername, driveLetter + char(10) + char(13)

from freedrivespace

If the last column is numeric or date, you will need to wrap a CONVERT...

b-boy, if your data source for the CSV file is a query you can try this...

Select + char(13) + char(10). This will append CR/LF characters to the last...

Look in the SQLAgent log, SQL error log and event logs for failures.

Read Steve's editorial from today.

Again, quite the opposite results on my system. After a reboot, first declaration took about 3 seconds. After that, they declare instantly.

DAB

This is interesting. I created some table variables and looked at some counters. The FIRST time I created a table variable (a small one declare @t table (myI int) )...

What specific counters have you looked at?

DAB

Similarly, I've called a vbscript file from xp_cmdshell and wrote the .bat file.

DAB

I ran it. It told me exactly what msinfo32 tells me: total number of cores. It didn't tell me physical sockets or whether or not Hyper Threading was turned on.