Please advise - Patching questions - Hi All, I am learning and honestly think this is a great platform and have some basic patching questions. 1. Can I...
Login sa failed - Hi All, Please advise, Logon Login failed for user 'sa'. Reason: Password did not match that for the login provided. . Is some...
Column names on INNER JOINS - In my code below I have Invoices.InvID
how to get rows from two datetime fields with hours on morning time. - I have this problem How can I get rows in this example. We are looking for crimes in our database...
Composite indexes; performance - Hi everybody, I have couple quick questions for the DBAs. We have 2 heavy SELECT statements in 2 stored procedures, that are...
SSIS Toolbox Different on 2 Servers - I have 2 servers running SQL 2016, but 1 server seems to have "Lost" toolbox items that were there before....
Purchase Order query help - Hello Experts, Needed some help with a query, the requirement is to identify an Item that is getting ordered but not...
Execute a Stored Procedure against every row insert in Table - I have around 200 tables and we have insert in each table with in each seconds. so there are around 90...
SFTP Options with SQL 2016 ? - Does SQL 2016 have any native support for SFTP ? Looks like previously 3rd party add-ins were the way only option.
Maintenance Plan "Ghost" - System details: SQL 2014 SQL Microsoft SQL Server 2014 (SP1-CU9-GDR) (KB3194722) - 12.0.4487.0 (X64) Developer Edition (64-bit) on Windows NT 6.3...
Subtracting in dynamic SQL - I was updating a stored procedure to change the reporting time to clients timezone. The stored procedure is comprised of...
How to overcome missing 0x for varbinary? - I have a virbinary(MAX) column which contains an encrypted data. We use standard encryption method EncryptByKey(Key_GUID.... to decrypt the data....
does use of large datatypes where much smaller ones will do, affect performance? - when a table has one hundred columns, where 40 of them have datatypes far exceeding the max(len()) of data actually in them, will this...
Converting delimiter - Is there a way to change a comma delimited file to pipe delimited using a script? Thanks.
Splitting a Full Name - I'm trying to split a full name column up into First / Middle / Last....but some of the names are like "Joe...
How to group similar data together in SSRS - Hi, I created a report and it shows below: Office Name Employee # ABC - OFFICE1 2 ABC - OFFICE2 3 ABC - OFFICE3 &n
How can I prevent the added group items from repeating? - I have a parent group and added two additional columns so they would all show as a group. My problem...
The restrictions imposed by the CONSTRAINED flag in the STRTOMEMBER function were violated. - Hi, I am trying to implement the "calendar picker" functionality in my report, obviously the steps for this functionality has...
Converting between binary hex and GUID (uniqueidentifier) - Sounds easy. but I'm trying to connect the field in msdb.dbo.sysjob (uniqueidentifier) to the text based binary version in...
How can I update original Ole DB Source after Multicast? - Requirement: I have a flat table that I need to split into many tables, and then timestamp (basically confirming the...