here's something i recently built to move specific clustered indexes to a new filegroup, and also enable page compression on some specific tables;

you'll see some commented artifacts referencing a table...

sure; there's a system view named sys.database_permissions.

this will give you users and groups that have the permission you are looking for...but you might need to expand group members if you...

DouglasH (5/25/2016)

---

You'll have to access the Extended File Properties of the file but I don't think you can do it with TSQL. The Extended Properties vary according to the...

In my case, i was bitten by the 2./3.0 when i wax using Export-Csv i think, which added -Appen parameter.

I ended up using a command line call to the...

can you run $PSVersionTable?

i'm thinking the script is for Powershell 3.0, but it's running under 2.0 context?

the third error i would think can occur if the string $DestinationFile has...

in that case, your count, as you currently have it, would always be one, since the WHERE statement is limiting data to the same day the person died.

you have to...

i would think do the following

add a new column, ie

update it to the equiv orig value, maybe in small batches

rename orig column

rename new column

drop orig column

ALTER TABLE myTable...

boehnc (5/24/2016)

---

thanks so much for your response Lowell. If, for example, a person who dies on Jan 1, 2015, I would need a count of visits from Jan 1, 2014...

assuming DCDate is the Deceased Date, and you can only die once(except in the movies)

here's my best guess:

SELECT

a.PatientNumber,

MAX(a.DCDate) As DCDate,

Count(a.PatientNumber) as PatientVisits

FROM [PatientData] a

where a.DCDispCode = '20'

and...

here's the script with all columns in T.* exploded out to their full name.

you can remove what you don't need easier than i can.

object_name(object_id) has an additional optional parameter, db_id,...

isn't error 0x80004005 file permissions, ie cannot access \\servername\sharename\filename.xls?

this is probably after you publish /delopy the package(so it runs under a different user on the server), but works fine...

well here's how i do it:

deadlocks are already in the extended events. nothing extra needs to be done with that.

i have a stored procedure that pulls the "latest" deadlock from...

i did this once, but it's been a while, and it actually worked.

same issue, hardcoded code to three part naming conventions.

it's been a while, but i obviously made sure i...

it's just syntax.

you want to select modified data, and insert is still just an insert. i saw what you were tryingto do, though.

below is a better example

Insert INTO (

[ScenarioID]

,[CostCenterID]

,[CostCenterName]

,[FunctionID]

,[FunctionName])

SELECT 'Budget2013'...

My prod system s busy, but not 500 queries per second busy.

I've run that particular query quite a few times on production, during prod hours, since it's hitting the DMV's,...