if your filegroup is not empty, you might need to alter some indexes and recreate them in another file group.

this would show you theFileGroup Name and the file a given...

absolutely great job on providing the set up sample scripts.

Am i underthinking this, that it is simply a group by problem, maybe with a NOT EXISTS?

it looked to me...

sp_whoisactive can send it's results to a table.

a simple example:

CREATE TABLE [master].[dbo].[MonitoredActivity] (

[dd hh:mm:ss.mss] ...

yes. you can create a credential with windows credentials, and then a proxy in SQL agent.

with that in place, you can modify the job step that calls the SSIS package...

if these were medical diagnosis codes, i know diagnosis codes vary between three and eight characters in length;

here's a couple examples

463

W45.8XXA

so i think using a delimitedsplit is...

here's how i started tackling it: strip everything out, and then format depending on 10 or 11 digit lengths.

I think i'd remove letters and replace with their corresponding numbers...

I'm ignoring...

you are probably using notepad to save your file?

you have to change the file type in the save as dialog.

Change it to all files and enter the extension...

why can't you rename the databases?

exec sp_renamedb 'Account ','AccountOrig'

exec sp_renamedb 'Account_Compact ','Account'

here's an example that i just slapped together that does the first nine columns. using DelimitedSplit8K and the PIVOT operator.

does this help?

/*

--Results

Diagnoses_For_Spell ...

I still think a specific set of volunteers here should be given a whack-a-mole functionality, which has been suggested ad-nauseam, but I think it's hard for red-gate to dedicate a...

template functionality in the paid SSMS plugin ssmstoolspack.com does that.(~40 bucks as I remember)

it also is parameterized for variables.

for example, my template looks like this:

-- Created By: |CurrentWinUserName|

-- Create Date:...

dudekula.kareemulla (5/19/2016)

---

Is there any possibility to give select privilege permission with out creating same user in another database??

Problem is i do not want create same user in another database in...

i think synonyms don't magically solve cross database chaining.

if User [Bob] has access to [db1], but a synonym in there points to [db2], you need to add [bob] to...

I like the direction Joie Andrews was going;

look at the job history, andn see how long it takes.(the duration column)

if you set it for every 15 minutes, but it takes...

kruezer had it right; without data and substantially more information, it's just a guess.

if i said 700 gig is required, and kruezer said 80 gig , who has the better...