While you can use the sys.dm_db_index_usage_stats view to identify when an index was last accessed by a user, this also requires that you make assumptions regarding the last time it...

If the Excel attachment requirement exists, that will make things a bit more complicated to perform this using T-SQL. I believe it also requires 'Ad Hoc Distributed Queries' enabled as...

I'm actually stuck in that boat myself trying to finish off the MCSE: Data Management and Analytics now, before it's retired. I can appreciate the new direction Microsoft is taking...

Nevada, as you mentioned the single quotes around each item being inserted into the corresponding "char" columns will fix the issue. The values turning red seems to indicate there was...

• This reply was modified 4 years, 9 months ago by  BTylerWhite.
• This reply was modified 4 years, 9 months ago by  BTylerWhite.

I agree that Powershell would be far easier, and could easily be executed by an Agent Task in SQL Server if needed. Should look something like this:

            
December 30, 2019 at 4:56 pm
            
#3711226

            
            
                                                
        

Hey George,

The PackageFormatVersion is still 8 with a TargetServerVersion of SQL Server 2019. It was previously 6 with SQL Server 2012, but has not changed since.

With the newest Integration Services...

Thanks for the question, Steve! This was fresh on my mind after having recently read jonfrisbee's article on the subject.

Great question! I've been enjoying the computed column questions recently, as I don't work with computed columns very often. As mentioned previously, it does look like the answers are using...

If you had the following table:

person_id|first_name
---------|----------
1 |John
2 |Wally
3 |James
4 |John

The query in your post would return:

person_id|first_name
---------|----------
1 |John
2 |Wally
3 |James

Which removed the other "John" with...

Hey John,

Based on the previous answers, the sys.objects view with a search condition on is_ms_shipped would likely be your best bet to accomplish this.

Using SQL Server 2017, you can also...

Are you asking the best way to store the data?

The HTML character set was extended to ISO 10646, which is similar to Unicode. I would recommend using nvarchar (MAX) or...

Hey George,

This gets into a rather tricky area. Referencing error message 15250:

"The database name component of the object qualifier must be the name of the current database."

As John suggested, this...

• This reply was modified 5 years, 1 month ago by  BTylerWhite.

You could use ROW_NUMBER() to partition by the AppNumber and order by the Time_GeneratedAt columns using SQL Server 2008 R2. Using the LAG() or LEAD() function would be more ideal...