Availability group listener is not listening - I've successfully created an availability group with 2 nodes that one node is physical and another is VM. Also running...
How to select the last record added to a table - I am in the process of creating a table of widgets (obviously everything about this example is fictitious including the...
SQL Quiz - Removed as per the wish of a user !
Database in RECOVERY PENDING state - Access Denied - Hi I have s SQL2016 instance with 8 out of 10 databases in recovery pending state and I need assistance. I had...
Shrink database only x gig a week. - I just added the new columnstore indexes on to the database. This saved 2 TB of space on the indexes. I like to...
How to Create Linked server for CISCO Telephone Informix database - Can any one guide me step by step What is required and how to create a linked server for CISCO...
Storing a hash of a row - Hi Folks, First of all, happy new year to you all! TL;DR - I need to store a calculated hash value from a...
Query to Check - Hi, I was hoping to get a query that will show me CPU, memory used, and Disk IO for SQL...
Determining uncompressed size when removing Row level table compression - Hello, I'm finding one particular table with very high CPU usage. This table has ROW level compression. Does anyone know a way...
Update stats - Question: in my production server I had noticed the update stats job was failing for few days due to deadloock.....
Rebuild index taking time - Question: rebuild index task in a SQL 2014 ENV is taking a long time to compete. what to check and...
Insert Faster way - Guys, I need to improve this Insert in a faster way Query : set identity_insert .dbo.JOB ON INSERT INTO ..JOB ( , , , , , , ,[FROM_S
Query Performance - Hello All, Wish you a very happy new year 2019!! I had been asked to review performance of a procedure and I...
Date Field Calculation Logic - Can somebody please help with this issue... /* Here’s the problem: Let's say we had a table of all US Presidents, with...
Does Stored Proc Complete if Machine Rebooted? - I am running SSMS on my machine in the US and connecting to a server located elsewhere in the world. I...
How to change CDC Function fn_cdc_map_lsn_to_time(__$start_lsn) to return UTC Datetime - Is there any possibilities on change the Return Datetime of sys
Trying to add a running total to my query - I'm having trouble adding the running total to my query. See attached for data. Here's where I'm at now but,...
Orphan SSRS SQL Agent Jobs? - The following query returns 6 SQL Agent Jobs that appear to be for SSRS subscriptions that no longer exist. Can anyone...
Parsing Nested XML file - Hi , can someone please help me in getting the simple method of parsing the XML file in SSIS. I was...
Translate Sql Query to Clr - Hello, How can I write the following query in c# clr ? CREATE FUNCTION SQL_HT ( @param1 INT, @param2 INT)RETURNS@tablo TABLE( colon1...