Metldown and Spectre - Has anyone deployed any of the patches released for SQL 2016 and SQL 2017 to any of their environments. Is anyone...
Error running execute xp_cmdshell - Hi All I can run this from the command prompt C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -ExecutionPolicy Unrestricted -File C:\DailyEtlData\EtlScripts\Powershell\MoveFileDirtoDir.ps1 -SourceServer C:\inetpub\ftproot\ -DestinationServer C:\DailyEtlData\Connect\PreLoadFilesFromFtp\ -Filename 20171202.dump.gz if...
Divide column data into equal parts - I want to split one of the column's data into 8 equal parts. For eg. i have 73 rows currently...
Migrating Database Engine, SSIS, SSRS off of a server to have SSAS be on its own server - I have a requirement to make an existing server only run SSAS and migrate the Database Engine(and the perspective databases),...
IN-Memory tables - Hello All! I would like to know what is the the pros & cons of In-Memory tables in SQL Server 2016 In addition...
Suspect database - not urgent - Had an issue recently where I found a database in Suspect mode. No access was possible. Started to look through logs...
Ola's maintenance solution taking too long on VLDB's - All, I am looking into optimizing Ola's maintenance solution by tweaking around some parameters that is part of the stored proc....
Row inserts for groups of rows (Totals for groups of like data). - I want to group data like all invoices from a supplier which is easy enough but when selecting multiple suppliers,...
Detecting change week over week in SQL table - Hello everybody, trying to figure what is the best way to figure out change between snapshots of project records. Snapshots are...
SELECT all negative values, that have a positive value - Hello, I need to identify in SQL server table all entries with a negative value, that have a positive value. How...
Issue with ROW OVER partition - I was able to get this far from other posts in this forum, but keep getting error . . . invalid column . . Max_Date The...
Convert from datetime to varchar to int - Hi All, So I've been working on an SSIS package and part of it involves pulling data from a table's datetime...
CASE statement slows down query drastically - If i comment out the case statement in this query, it takes less than a second. With the case statement,...
Searching strings - Hi all We've got a 3rd-party application and an associated database. We need to join two tables together but, unfortunately, there's no...
Weird Character - I imported data into SQL Server using a link server. Imported an Excel version and a CSV version. One cell...
Composite Key Assistance - Hello, While I've searched this topic with some hits, I've never been able to fully digest this to my satisfaction. My...
How to Pivot Financial Data Rows Into Dynamic Columns - I'm assuming this technique has a commonly used name/term and has been solved many times and if that's the case...
error: non-existing report parameter - Hello Everyone, I get this error: "The value expression for the query parameter '@eDate' refers to a non-existing report parameter 'eDate'....
The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is '164'. The expected version is '163'. - we are getting the following when we updated from SQL 2012 SP2 to SQL 2012 SP3 The version of the...
Error 208: Invalid object name ''msdb.dbo.MSdistpublishers'' - Hi Guys, We have a server setup as a distribution server, which manages the replication to & from 3 other SQL servers. Last...
