Antivirus Exceptions - Yes or No? - Hi Folks, I heard an interesting conversation today about whether or not Antivirus Scanning exceptions (in this case provided by McAfee)...
Help with aggregate function - have table: col1 col2 col3 A B 10 B A 5 C D 8 Want to get: A B 15 C D 8
Issue with agent job while taking backup - EXEC msdb.dbo.sp_send_dbmail @profile_name ='DBA', @recipients ='arvindinfa2014@gmail.com', @subject = 'Differential Backup Report', @execute_query_database = 'master', @query='EXECUTE .', @body_format='html', @body='Differential Backup of USER Databases taken successfully on Server1', @exclude_query_output=1, @append_query_erro
Grant execute to procedures doing SELECT only - Hi, Our staff members all have only db_datareader permissions and View definition on all production databases. But many times they require to...
FCI + Always On - Hi, I want to setup a 3 nodes solutions. NODE_A, NODE_B and NODE_C are part of the same WSFC. Node_A -> Contains...
Multiple AG groups in one Windows failover cluster? - In an organisation I found the following setup: Six VMs SQL1 to SQL6 in the same domain, each host two instances....
Newbie point-in-time restore question - Hello experts, I have the following scenario and am wondering if someone can confirm the steps for me. I know how to...
C# String treatment - Hello, I have a line of code like: Filenameonly2 = line I get a result like: When I do messagebox.show ( Filenameonly2 ) I get: 16 DIVIDENDS...
Creating databse backups automatically in specific period of time - Hi Guys, I am creating back ups of my database using code: USE QlikView; GO BACKUP DATABASE QlikView TO DISK = 'C:\Program...
To Index a Computed Column... - Hi All, So in an effort to optimize a larger query (which I've posted about here before), I'm trying to utilize computed...
Issues with matching pattern using LIKE - Why in God's name does this not work? expecting "dateFirst": DECLARE @searchString
SQL 2012 - Interview Questions (Sample) - Hi Guyz, Warm greetings ! I'm very happy to post some interview questions today which I'd faced recently via a Skype. Could you please...
Selectivity vs SARGAbility? - Hi All, What is the difference between Selectivity and SARGAbility? Thanks, Sam
Using the Key Lookup and Index Seek Properties to construct the missing indexes - I was just wondering about the 'math' behind using the properties of the Key Lookup and Index seek operators to...
bcp changing high ascii values - bcp appears to be changing some high ascii values on import (eg 249 to 168). How can I control/prevent this...
Replace TABLE with STAGING_TABLE. Approach? - I have a Stored Procedure which does some ETL "stuff" At the end of the procedure I want to replace a...
Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ? - I have a table with 4 columns and 10 million rows in which I want to update 1 column I have...
Stupid Question: Return Object Explorer to It's original position - Stupid question but I accidentally moved object explorer from it's original default position on SSMS. By default, object explorer is...
dynamic billing cycle - Hi, We have a parameter which shows dynamically the billing cycle in the report, our billing cycle is from 21th this...
Database in Recovery Pending State - One of my databases is in Recovery pending state. I tried to run an Alter command on the database to...
