SQL Migration - I have a SQL Cluster with Multiple databases. some small and large spanning multiple NDF Files. My question is this. I...
Automate date to always show current Tuesday - Hi Guys, At the moment I have to run the a query and manually change the date every Tuesday. So every...
SSIS Package run from Visual Studio but fails from SQL Server Agent with the Error: Exception has been thrown by the target of an Invocation. - HI, I have an SSIS Package which goes to a website using http connection and gets a zip file and loads...
SQL 2016 SSRS Native Mode - Report Loading Time - We are running SQL 2016 SSRS in native mode using the web portal. If a user is part of the...
SSRS - There is a problem with this website's security certificate - I ran into issues when using the SSL Certificate for SSRS. The certificate is valid and have been issued by...
Hide schema from all users (except people with SA access) - Hi all I need to create a schema to store a set of tables but I don't want anyone (including those...
Mirroring Failover - I have question, Server A is mirrored to Server B when the failover is done server B would be principal and...
Always on Install - Hi I am following these notes for always on install and have some basic queries: http://www.sqlservercentral.com/blogs/ganapathis-mssqllover/2017/02/20/alwayson-availability-groups-step-by-step-setup/ For step 9 Click the Add… button
AlwaysOn Listener registering 2 DNS records - Hello We have a situation where we need to setup AlwaysOn configuration on 2 data centers When I create a Listener providing...
Query Layout - Could somebody check the uploaded photo of a screen print of a report I need to make? I've never made something...
DATALENGTH and LEN difference between NUMERIC(16,6) and NUMERIC(18,2) - Due to one of our customers request in the past, we used to keep financial information across our product in...
When is too many columns too many columns? - I know you can have some insane number of columns in SQL server... but just because you could, doesn't mean...
Mirroring - Working on setting up SQL Server mirroring. Following are the steps I am thinking to do.. Take Full Backup and Transaction...
SQL jobs interfering with eachother - I have 2 sql jobs running daily (nightly) on the server. These are scheduled 1:30 hr/min apart. Both these jobs have...
Dilemma when refreshing UAT from Prod - Hi all, We have an automated job that kills all connections to a DB on UAT, restores a full backup...
Separating SSIS Datetime - Hi Experts, I have a text file to load to a database.The file has a column Datetime 2013-07-16 15:05:43 and in...
How to update a field with the result from a Query - Hi all! I have this query: SELECT Per.per_personal_id,EMP.vacation_model FROM dbo.personal PER JOIN dbo.employment EMP ON EMP.EmployeeID = PER.per_personal_id WHERE EMP.DATEFROM <= 79508 AND (EMP.DATETO = 0...
remove Identity from a column - Hi Dudes, I have a Table Which has a column that is set to identity by mistake and it is on...
Lookup Transformation NCHAR - Hi, I have this table CREATE
Date formatting in a text string. - Hi All, I am not sure if I have put this in the correct section as am new to the...
