pretty sure SQLSACT is correct;

part of the update process is updating the indexes that are affected, so when the transaction is committed, bit the data itself and the indexes...

OUCH this is painful to even acknowledge I built this query, after seeing how dog slow it is!

my thought is the command has to look something like this, for every...

* also the Database Engine Tuning Advisor creates a trace with a NULL path, as well.

also I'm pretty sure a profiler created trace does not have a path: so you can do check sys.traces as a quick sanity check, and that would tell you...

As usual Sean's got it covered; about all i can say is null columns or tables with zero rows, is missing / no data often doesn't mean the objects can...

it's effectively a script which performs the same operations as this GUI menu "Shrink Files" in SSMS performs...the followup screen lets you select either the database file(s) or the log...

no, but the features differences all really have to do with a lot of advanced things, that would never come up in basic development; they come up more along...

xpreaderrorlog doesn't have a column dedicated to the database name, so no, there's no way to filter based on a LIKE statement directly.

there's a pretty good recap of the...

nikunj_lodhi (7/2/2013)

---

Hi Folks,

I wanted to know that can we have a single instance on two different databases?

I am till now aware that it is a one to one relation(correct me...

the format of your question screams "copy and paste" from your homework;

That's a little frowned upon here, so lets do it right:

can you show us the query you've created so...

well, if you are in SQL2005, you cannot take advantage of the FileStream data type.

In that case, best practice depends on the size of the files you want to store....

that C_recId is probably a varchar?

adding a format to the order by might help instead:

select *

from customer

where C_recid in (50200,50194,50430,50191,1)

order by RIGHT('00000' + C_recid ,5) DESC

try this to avoid integer division:

if sql divides two integers , it returns an integer datatype, which can get rounded or truncated.

SELECT ((count(item_keya) * 1.0 / count(snetworkname) * 1.0) *...

SQL_TASK (7/1/2013)

---

I have 2 database tables.

1) From Production

2) From Dev.

The task is to move the data refresh from Production to Dev Server. But the table schema itself is changed is...

i'm guessing since you are using powershell to substitute values, the date parameter must be in single quotes;

also, it looks like $Date_Import would get substituted too, which makes an invalid...