Unable to connect to SQL 2008 Servers from SSMS 2017 - Servers are running on SQL 2008 on Windows 2003. Client from where I am trying to connect to those servers...
SQL Server Multiple Databases Management Solution - Hi Senior DBA's. Do you know of a way to automate the below requirement to create a daily report ( on a...
70-461 exam - I bombed this exam and afterwards discovered the 70-461 Querying Microsoft sql server 2012 book has nearly all the material...
Backup size and DB size are different. - I have a DB which is supposed to be close to 250 GB in Size. I have couple of scripts...
Can't open the master key on Always on SQL Server - We have fail-over cluster for one of our production environment. It has two node with SSISDB configured. Someone has configured...
Need to remove punctuation characters - Hi, I need to remove any punctuation characters at the end and before new line. Please help.
SET NOCOUNT ON at instance level - not working. - Hello Members, I have configured nocount as default connection property using following command. EXEC sp_configure 'user options', 512. Unfortunately, when I connect...
Transaction log full error - The database is in simple mode and when I try to shrink the log USE db1
Login failed password did not match for SQL loin - Hi , I am getting error when i login SQL Server 2012 ' Login failed password did not match" buit i can...
Query performance tuning - Slow execution time - I've been tasked with performance tuning the underlying query. I have attached all the necessary details but if there is...
Query performance tuning - taking more than 9 minutes - Below is one of the reporting query that is taking almost like more than 9 minutes to complete and as...
Time increments - Hi, I want to have a calculated field "TimeIncrements' that will increment 20 minutes starting at 8:00 and ending at 5:00...
Maintenance Plan mystery - Hello Everybody, A maintenance plan in one old server (running SQL server 2008 R2 SP3) has 'backup' and 'Maintenance Clean up'...
Log file just doesn't shrink - Hi Everybody, Log file of one of our databases grows very high (now over 200 GB) . I have been shrinking it...
determining recommended indexes or indexes that are being used - Hello All, We run 2008R2 enterprise edition of MSSQL server. There is SPID on the server that we plan to monitor (and...
Subroutines in TSQL - I am a heavy TSQL coder, I love the many aspects of TSQL but I always wonder why we should...
xp_cmdshell works and then doesn't work - A stored procedure intermittently fails, and it appears to be because xp_cmdshell stops working. If I try it manually, here is...
Deducing from Wait Stats - Hi Everybody, The wait stats on the database I am assigned for performance tuning , shows that the PAGEIOLATCH_SH and CXPACKETS share...
Advice please - how to train up on API integrations - Hi all My company has a product which is based on SQL Server 2014, and we're looking to add some integrations...
SSIS to Execute SQL Query on Teradata, Return Results to SQL Server Database Table - Hello, I have a single Teradata statement query, in a SSIS package, with a single Execute SQL Task. In that...
