At a previous company where we used internal server disks, instead of SANs, we used an interesting mix of RAIDs for the different drives. And as usual the answer is...

Can you please post the statement that you are using? and the error...

From what you have said, you cannot "attach" a backup, you need to restore it.

Learned something new - thanks

simple solution for me, take the total table size, divide by the total number of records in the table and multiply by the number of records chosen, unless you need...

Shawn Melton (12/13/2010)

---

Along with VMWare tools you can open a command prompt and type in "systeminfo".

It will spit out a good many lines but go back to the start and...

I have had to deal with audit data stored like that. then they (supplier) decided it would be a good idea to add a tab to show the user the...

Heres an example of a SELECT statement I use and it comes out nicely formatted :-):

DECLARE @tableHTMLVARCHAR(MAX)

DECLARE @tEmailListVARCHAR(MAX)

DECLARE @tProfileVARCHAR(128)

DECLARE @tEmailSubjectVARCHAR(2048)

SELECT

@tEmailList = email_address

,@tEmailSubject = CAST(@@SERVERNAME AS VARCHAR(128)) + ' -...

Others to consider are SCOM (Microsoft System Center Operations Manager), Quest tools, loads out there.

Personally I prefer an agent based install VS a remote connection

Reason being that when things go...

Theres no simple report to to tell you yes, that can go on there.

Even with the advise given, you will still need to be able to interpret the data...

and as I said (even on a single disk) with partition, SQL Server has look at much smaller subset(s) of data in order to retrieve the row(s) in question.

So...

It depends on the process, but, if the update is done once a day, then on day 1 you update table 1 while table 2 is still in use. You...

There can be gains on partitioning the data, if appropriate. Ideally you should be selecting small sets of data and if the partition is appropriate then you will be selecting...

What is happening that the Price table is locked for so long? Price updates? Where do the changes come from?

I would consider a 2 table approach... 1 online table...

mwwheeler (12/21/2010)

---

I have a table that gives me the error above whenever I try to add a new row. Ive managed to find the row thats causing the problem,...

GETDATE() for no other reason than habit.... and the "odd" timestamp column.