HOG (1/2/2013)

---

Is it possible to run a query that uses a date range, but if the records do not have any data, to then go back six months before the...

Rama Chandra Gowtham. Peddada (1/2/2013)

---

Attaching and restoring databases from one server instance to another are common tasks executed by a DBA.If we move our database to another SQL Server instance...

For details see this link http://www.mssqltips.com/sqlservertip/1590/understanding-and-dealing-with-orphaned-users-in-a-sql-server-database/

4 years old thread

Mac1986 (1/2/2013)

---

1) I see that Indexes have heavy fragmentation levels: This effects the DML Performance for sure, but will this allow the data file size to grow extra than...

venkatesh.b 88975 (1/3/2013)

---

While doing the 3rd step, In the other job the TEST DB is used by some procedure that job got failed.By change the job running times we can...

kyleheath33 (1/2/2013)

---

Was the TempDB data file on that drive? A restart of SQL Server will rebuild the temp database so could have released space that way. Could also be an...

i tried it with PIVOT but its more resource intensive (as compared to other provided solution ) . can we avoid UNION here

SELECT CompanyName, 'Low' as Type,

[Sunday], [Monday],...

see this

--Bpool stats

select (bpool_committed * 8192)/ (1024*1024) as bpool_committed_mb

, (cast(bpool_commit_target as bigint) * 8192) / (1024*1024) as bpool_target_mb,

(bpool_visible * 8192) / (1024*1024) as bpool_visible_mb

from sys.dm_os_sys_info

go

-- Get me physical...

tbmabry (1/2/2013)

---

I tried this but it didn't work. I don't know what the emails are going to be they are from all over the U.S. There are over 4000 records...

jitendra.te (1/2/2013)

---

I have a Query Please help me out about this:

Scenerio is, I have a database server which have a harddisk size is 70 GB c drives is occupied...

+1...

try with another paramter [ @body_format= ] = 'HTML '

it seems that you went straightaway to apply this . to gain some space. and if thats the case then you might...

If you go with the basic structure of HASH join then you will find that temp table get created (either in memory or tempdb) which might the cause of tempdb's...