Tags » SQL Tips And Tricks

SQL Server - Error While Enabling CDC on a Table - The specified '@server' is invalid (valid values are returned by sp_helpserver)

Every environment is different and it is no doubt some of these environment changes can give you results that are not expected. Recently one of my blog reader followed below blogs: 477 more words

SQL Authority

SQL SERVER - Different Methods to Know Parameters of Stored Procedure

Suppose you have a stored procedure with some input parameters. There are two methods to know the list of parameters defined in a stored procedure. 145 more words

SQL Authority

Hey DBA – Watch Your Vendors! Hey Vendors – Try a Little Harder! - Notes from the Field #077

: This is a 77th episode of Notes from the Field series. Every week, I personally wait for the notes from the fields from Mike because it contains lessons of life which directly impacts DBA and Developer’s life positively. 1,422 more words

SQL Authority

SQL SERVER - How to Identify a DB is Using Cross Database Transactions?

I cannot iterate this often, some of the best learnings always come from times you least expect a question to come from. Recently, when I was at a conference in Delhi, one of the attendees came to me to ask a question. 546 more words

SQL Authority

SQL SERVER - Split Comma Separated List Without Using a Function

The best way to learn something is to revisit some of the older blogs and then look at finding a more efficient way to work on the same problem. 303 more words

SQL Authority

SQL SERVER - How to View the Dirty Pages In Memory of a Database?

I always get an opportunity to talk on topics that are basic from time to time. As I was preparing for GIDS 2015 (Great Indian Developer Summit) this year, I was vividly remembering one of the conversations I had with an attendee last year at our Pluralsight booth. 556 more words

SQL Authority

Interview Question of the Week #016 - How to Take Database Offline

Here is the question, I received in the recent conference where I was presenting on Database Technology.

Question: What does it mean by Taking Database Offline and How to do it? 101 more words

SQL Authority