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...

ouch, the custom delimiters finally soaked in; that' certainly adds tot eh complexity, since i'd normally BULK INSERT something custom delimtied...but you need the tables built on the fly,...

Lucas the plain set @provstr = 'Text' was what is working for me; the other one was one that i was testing, and not applicable here.

for the error you...

NJDave (7/1/2013)

---

Hello

An application that sits outside of our network will allow the user to store pdf files on the database.

The concern is that these pdf files could contain viruses.

The vendor...

Lucas the strategy depends on the details.

I'm not anti -SSIS, but if it can be done via TSQL, then it can be done a lot faster.

if the destination tables...

ok, if you cannot remove records due to your audit requirements, i think it comes down to query tuning;

can you grab some execution plans, and see if any of the...