Tags » SQL Authority

SQL SERVER - Increase Characters Displayed in Text Results

Working with various SQL Server options is always a great feeling. Every now and then I go to the Options page to get just the thing I want. 284 more words

SQL Authority

Interview Question of the Week #030 - Retrieve Last Inserted Identity of Record

Question: What are the different ways of retrieving the identity of last inserted record? Which method do you prefer?

Answer: There are many different ways to do that. 297 more words

SQL Authority

SQL SERVER - How to Remove All Characters From a String Using T-SQL?

In the recent past I have seen the best interaction and learning happens when we all get into a puzzle and challenge mode. And that just gets the creative juice in our minds and some really innovative solutions are given. 167 more words

SQL Authority

SQL SERVER - Puzzle - Inside Working of Datatype smalldatetime

In the recent past, I have been bringing few puzzles around using date and time functions. All these have brought some awesome feedbacks and you all have been sharing some awesome answers. 302 more words

SQL Authority

SQL SERVER - DevOps for the DBA - Notes from the Field #091

: This is a 91st episode of Notes from the Field series. Divas is a new buzz word with lots of substance behind it. Not everyone understands what it means and not everyone actually related it to their daily job. 910 more words

SQL Authority

SQL SERVER - Error: Msg 245 - Conversion failed when converting the varchar value 'Inactive' to data type int

Using CASE statements is something I see a lot of developers use. They use it in complex environments and I have been fortunate to troubleshoot and look at code blocks that run for pages using the standard CASE statements. 369 more words

SQL Authority

SQL SERVER - Free SQL Complete Add-in For SSMS

This article covers main features of ApexSQL Complete, free SQL complete add-in. You can download the most recent version, and check its features while reading the article. 927 more words

SQL Authority