q1) I would say the reason is atomicity of the data plus permissions, and yes, portability. the permissions related to the database are contained in the database itself.

backups and...

Pieter-423357 (3/17/2016)

---

Need trick and scanning the AD-group is certainly useful, but wouldn't you want to know the real permissions in SQL Server itself to the Database level? Or at least...

I've seem this before;

What I've seen is that while 99% of the calls to the [production] database are perfectly normal, sometimes the database context gets lost, and the the default...

i'd like to see the actual query and an execution plan;

you might have a non-Sargable query, functions in the Where clause, a catch all query containing a lot of OR...

typically, you grant on a per-table or per-procedure basis when you want to restrict access to SOME of the tables.

what happens if new tables are added, or a table/proc is...

exporting to csv is no problem, even if there is 2.5 million rows.

opening it IN EXCEL is an issue, since it will not support that many rows.

open it in...

monitoring is a big subject, and enterprise level monitoring certainly depends on your budget;

i think a lot of typical apps out there gun for $1K per monitored server, with discounts...

you could do something like this:

a combination of the ccommandline type command and xp_cmdshell, you can ge tthe file contents of your *.sql files and execute them.

I just built this...

my first example, where i used delimiters that never occur in my data is a solid example of exporting and importing data with whitespace and dbl quotes int he contents,...

ok, bcp IN supports the quoted identifier, but not when you use bcp out/queryout;

it's been a while since i did bcp, i switched to Common Language Runtime to do my...

only if you change the datasource to use their AD credentials, instead of the cached username/password.

In that case, the end users most likely don't have permissions to query the data...

the order of the flags shouldn't make any difference, but i think if you run bcp /?, and put flags in the same order as the help specifies, that would...

you have to go deeper.

all that does is turn the string into a table. join that to another real table.

replace the function with dbo.DelimitedSplit8k(@Specimen,','); and CROSS APPLY that...

here's an example of a four character column delimiter(the -t) and a four character row delimiter(-r).

just put your pipe in dbl quotes.

i think if you just add the minus q...

Last YEARS data?

i thought you said last week.

the join criteria is the datediff info: i'm...