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...

The excel data doesn't allow anyone to set this up, nor does the Word document make it easy to understand what you did.

It's helpful to say, I run this:

select unitid

...

tripleAxe (4/20/2016)

---

I've done this recently. Got burned with letting...

First, it's helpful to give some mockup like this, using some sample data:

CREATE TABLE Service

(

UnitID INT

, Servicedate DATE

, ServiceType VARCHAR(200)

,...

When you baseline, compare that to your current prod environment as well to see if you can extrapolate the perf levels between them.