Haven't seen this much. Typically people just let SQL cache things itself, but I could understand how a large load might benefit here, distributing some of the work.

I know a...

Why? That's the architecture. No reason to do more than need to understand this. You can complain to MS, but I doubt they're changing this anytime soon, and certainly not...

Two ways:

1. Use a trace to capture when tables are queried. Takes time, and not necessarily correct.

2. Use a file search mechanism against all of your .RDL files in the...

MadAdmin (4/22/2016)

---

Check to see if the indexes are being used, or if they are duplicated, or if you can create better indexes, i.e. consolidate.

It would be horrible to rebuild 800GB...

Along with the requests for information, learn about indexes. We can't just say index col1 or col2. Indexing needs to be balanced across your workload. If there are thousands (lac)...

That's the wrong guy. He's dbpub.com. There's a db-pub.com (hypen) that shows up, but isn't loading now.

No. You can add a database on SQL 2014 in R2 compatability mode, but not a SQL 2008 R2 instance.

The format for databases and logs has changed.

Brandie Tarvin (4/21/2016)

---

Okay, this is weird. I went searching for an error I got in SSIS 2012 and the first thread that pops up in Google is a thread I...

Gary Varga (4/21/2016)

---

Iwas Bornready (4/21/2016)

---

What? I can't make one guess per day. Do I get extra guesses if...

Pher (4/21/2016)

---

Using SQL 2012

-- Msg 195, Level 15, State 10, Line 5

-- 'NVARCHAR' is not a recognized built-in function name.

-- The TRY_Convert function requires 3 argument(s).

SELECT TRY_CONVERT(NVARCHAR(1), 234523)

Did I miss...

Explanation was incorrect. I had char and varchar, instead of nchar and nvarchar as the datatypes where an error should be returned.

Apologies for that. It has been corrected. I have...

You read T-R-Y-_-C-O-N-V-E-R-T as S-U-B-S-T-R-I-N-G

Not sure what this means. I assume you mean collation, which probably maps to Charset somehow. This would be SERVERPROPERTY('Collation'), but this can be set at the database and table...

Use a trigger. Build it for alters, and when a column value changes, write to a new table, with the date/time.

Note that there's no order to the rows in a...

Connect usually comes with the login creation.

Password policy is under the login properties, or here:

select

select

LOGINPROPERTY(log.name, N'IsLocked') AS IsLocked

, LOGINPROPERTY(log.name, N'IsExpired') AS IsPasswordExpired

, LOGINPROPERTY(log.name, N'IsMustChange')

In terms of user...