How to enable SQL to connect with servername\instance with 2 node sql cluster? - Hello, How can I make it available to connect to sql using servername\instance name with a SQL 2 node cluster? If...
reboot server configured with AlwaysOn setup - hi i have 3 node server with alwaysOn setup 1-primary 2 -secondary 3-secondary. wanted to reboot any of them, is there any...
SA Password Unknown - Hi to all. SQL 2016 was installed in mixed mode. I cannot recall specifying SA password for a particular instance...
how to deploy 10 T-SQL scripts across 200 databases - Hi , Can any one suggest an efficient way where we can apply about 10 T-SQL scripts on about 200 databases...
Error 0x80070057 when creating maintenance plan - Hi, I have just installed a new default instance SQL 2016 DEv CU2 Windows 2012R2 Standard Basic features: DB , search,...
TDE Certificate backup - Hi Guys, I am trying to backup a certificate that I created for TDE but I am not successful. Please see...
Search a string in entire datababe - Is there a script to search a string stored in all cell of all tables? For example, I want to find...
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...
Trying to determine what might be causing skipped values in an IDENTITY column - I've got a tough problem which comes back occasionally to plague me. I have to help maintain a legacy MS...
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...
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...
Update same row twice - I know this is illegal with a merge, but is there a way to update the same row twice with...
pulling records from a table between date ranges in another table - This seems simple enough but for some reason, my brain isn't working. I have a lookup table: Table A: basically dates every...
Subroutines in TSQL - I am a heavy TSQL coder, I love the many aspects of TSQL but I always wonder why we should...
Can I restore a single file .mdf to multiple files spread across disks - I am trying to create a 2nd copy of my database which is 200GB so that I can do Log...
Enormous Page Life Expectancy (PLE)? - I've been running perfmon and analysing the results on a production Windows 2008 R2 server running SQL Server 2008 R2...
Using dtexec to execute a file system package with project level connection managers - I'm new to SSIS. I'm trying not to be a help vampire ;-) http://www.skidmore.edu/~pdwyer/e/eoc/help_vampire.htm I've read
Problems querying a linked server from a SQL Agent job - First of all, where are the SQL Server 2008 forums? So here's my setup. I created a linked server to a...
Error running SSIS package - Hi, We get an error running a SSIS package which calls another package. Both packages execute Ok independently. Error: "The LoadFromSQLServer...
Extract filename from fully qualified path - I have a varchar(255) column that contains the fully qualified path for a file. For example: C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyFile.txt I need to...
