I am working on a SQL Server 2008R2 query that leverages full text searching to find the appropriate rows with the data. However, and here is where I am stuck,...

bopeavy (6/14/2011)

--------------------------------------------------------------------------------

vmssanthosh

--------------------------------------------------------------------------------

hi

our manager is giving a new idea of having only one procedure for insert update and deleting all the master tables.

he wants to specify the table name and the...

vmssanthosh

---

hi

our manager is giving a new idea of having only one procedure for insert update and deleting all the master tables.

he wants to specify the table name and the values...

stebennettsjb

---

So im trying get an inventory of all the SQL boxs out there and im finding lots of Express edition 2005/2008 out there.

Do you do anything to these...

Krista Olson

---

I started using SQL 2008 Performance Data Collection, and so far the information provided has been great compared to another monitoring tool we use. The down side is there...

rajesh.bathala

---

My stored proc returning table a below

Name Date Size

................................................................

AAAA 15/04/2011 3

BBBB 10/05/2011 8

CCCC 11/06/2011 2

But i need data as per below format.

Name 15/04/2011 10/05/2011 11/06/2011

.......................................................................

AAAA 3 0 0

BBBB 0 8...

Scott H

---

Hi,

I've been asked by my company to spec and set up a brand new SQL server cluster, and while I'm mostly there with the spec, I'm having a bit...

GSquared

---

bopeavy (6/8/2011)

--------------------------------------------------------------------------------

GilaMonster

This is specific and unique to tempDB and likely has to do with what uses tempDB and how it's used.

To determine that a TempDB data file can be...

Perry

---

bopeavy (6/8/2011)

--------------------------------------------------------------------------------

And this Kind of thing is a pain when I have to get a time...

GilaMonster

Seriously, how often do you have to remove tempDB files?

For me (admittedly I'm not a production DBA, though I work a lot with them) it's 0 times in 6 years....

GilaMonster

This is specific and unique to tempDB and likely has to do with what uses tempDB and how it's used.

To determine that a TempDB data file can be dropped...

Robert Davis

---

For the tempDB questions, my advice differs a little from what others are saying.

I agree 100% that most systems do not need 1 data file per CPU (that's logical...

Isn't that truely a disadvantage that you can not drop a file without restarting sql server? i really do not care what db it goes to, if it has more...

I used the interface it was easier at the moment GUI>pickfile>removeButton

Yes, but I could do it as a user db, but it does not matter even the OS says that it does not excist yet I see it in the...