Find dialog box too small - Hi, does anybody know how to change the size of this dialogo box?
Upgrade SQL failover cluster from 2012 to 2016 - Hello, We are planning to upgrade our SQL server from 2012 (failover cluster) to SQL 2016 with Alwayson. I research a...
Publisher performance - transactional replication - We have setup push transactional replication, with the same server acting a both the subcriber and distributer. There are 28 Publications...
error in backup encryption - Hello everyone I need to encrypt my backup sql If I start the operation of the backup I come to have...
SQL 511 error on a SELECT statement - I am receiving the message while doing a SELECT statement. Msg 511, Level 16, State 1, Line 1 Cannot create a row...
Text data type - Is it still supported by SS 2016? Thanks
PowerShell Sql job - Hi, I 'm working to launch with a Sql Agent Job a powershell script. (the script is saved into network share because...
SQLCMD Error ODBC Driver 11 - SQL Server 2014 Enterprise Cluster Windows 2012 R2 Servers On the Node1 SQL Cluster server I am running SQLCMD scripts to...
SQL 2014 Cluster Setup on VMware - VMware ESXi 6.5 Windows 2012 R2 Cluster Servers SQL 2014 Enterprise My Windows Server Clusters validation ran with just two warnings...
Remove duplicate substrings from string - Hello experts, I have a problem I'd appreciate advice on please. I'm asked to determine distinct combinations of sequences of values...
Need to add MMM-yyyy to end of file in exp.builder-SSIS - Hello, I've built a basic ETL ssis package that drops an Excel file from on network share to another network share....
Prepared Statement Running Exponentially Longer - Hello All, I've seen this behavior now on 2 different queries on different databases, but still can't figure out anything on...
Calculating Date Difference - I have eight dates and these are in ascending order. But all or some of them can be null. Is there...
Synonyms and performance - How does the use of synonyms effect performance? More specifically, are synonyms replaced with fully qualified names in execution plans? It...
Using CASE in a View - I have created an employee View to which I need to add a calculated field called Calendar. All my internet...
Calcultion done in query not showing in ssrs report. - I'm doing all my calculations in the query, and showing them on ssrs. However, the following calculated field's value is not...
SSRS vs Crystal Reports - Does anyone know of a good article (link) out there on the pros & cons of SSRS versus Crystal? I need...
SSRS Counting Rows based on Date - Hello Everyone, I have a dataset that's bringing back 3 months of data, including a date. What I would like...
Visual Studio report designer and report parts - Hi all We've been using Report Builder from the SSRS web-page to produce reports and using Report Parts for standard items...
Creating derived columns from column of variable length components - Hi All, I'm hoping to get your guidance on this. I have a column, consisting of variable length sections that needs to be...
