Stijn Vervaet (1/12/2016)

---

Hi MadAdmin, I've continued my generation of DSQL SPs (an example you can see posted below), but unfortunately I see no such speed gains after testing multiple times...

ok, so you didnt want to update a particular statistic sniper rifle style.

That command will rebuild all statistics on the table, i.e. shotgun.

I am assuming you got the index name from the query I...

Stijn Vervaet (1/11/2016)

---

I want to try the Dynamic SQL generation, but something tells me that (especially since some of my tables have a LOT of columns, since this is...

All you can do is see if the message was qqueued for send here

select * from msdb.dbo.sysmail_mailitems

See in this table if it has info you could use.

Further than that, as...

The above is the syntax for updating all stats on a table like below

update statistics schema.table

If you want to update statistics it is

update statistics schema.table.STATISTICSNAME

So create statistics...

SQL Server Best Practices – Implementation of Database Object Schemas

https://technet.microsoft.com/en-us/library/dd283095%28v=sql.100%29.aspx

Jacob Wilkins (1/5/2016)

---

I'm not aware of any way to force connections to the read-only replica for particular logins.

When I've needed logins to have permissions solely on the read-only secondary, I've...

Login trigger on live server A.

No login trigger on liver server B

Do rollback if Login name = 'ThisHardenedDeveloper'

Must be something wrong with my version of sql.

Tested it out since I got the answer wrong, and query returned results without error.

My default quoted identifier is on, so maybe...

These types of...

Cardinality = 15089400 for Seek Keys

Actual number = 2454167 for seek key.

2.4 million concatenations.

Let us know the 3 tables row counts so that we have an idea, script out...

Try [msdb].[dbo].[sysdac_history_internal] and [msdb].[dbo].[sysdac_instances_internal]

SELECT

SUBSTRING(text, statement_start_offset/2+1,

...

Jacob Wilkins (12/22/2015)

CREATE TABLE #test (some_string varchar(max));

INSERT INTO #test

SELECT TOP 1000000 ac1.name

FROM ...