SQL Query to pull data - Hi, i have two table named "Objects" and "Attributes". Object Table Structure and Data: Attributes Table Structure and Data:
Performance Question - Hi there, I have a performance question here: how can I rewrite below highlighted area? I am getting Lazy spool in execuation...
SSIS Buffer Error - Hi, I am trying to execute a package and I am getting the following error messages: Error: A buffer failed while allocating...
Error Processing Cube from SSIS package run as a SQL Job - Hi, I am trying to upgrade a SQL server with Analysis Services to SQL 2017 cu5, 14.0.3023.8, (I tried CU4 before...
OLA script dont delete old trn file - Hello, I'm using Ola Hallengran scripts for maintenance. I have a SQL SERVER 2016 Enterprise edition and this DB is under always...
Registered servers - Hello - If someone creates the registered servers, can I use them to save time not to again add them one...
Return rows where value doesnt exist - Hello Everyone, I have a slight problem so I hope you can help. I have a table with orders joined to...
Storing multiple variations of the same data? - Can anyone weigh in on why you would want to store multiple variations of the same data? In all of...
Openrowset update issue - Hi I have a problem using OPENROWSET to move data from Server A to Server B correctly. I have the following requirement...
Importing from XML to SQL 2014 - This is my 4th day on SQL so I am a newbie. I created a query to import from an...
sp_send_dbmail - Error when passing @query parameter. - Hi All, When I send mail using "sp_send_dbmail" it works fine. But it fails when I set "@query" paramerter, fails with below...
SQL Query Help - Separate Column - Hi All: Need help with SQL Query. I have a column named Participants with Names and email addresses in one single column....
Log shipping and database backups - Hi all We've got a few databases that we want to start log-shipping from. Normally, we'd use replication but the 3rd-party software...
SSMS Solution queries prompt HRESULT E_FAIL error when trying to connect to servers - This is a weird one that I haven't seen until recently. As in after I upgraded my PC from Windows...
SSMS Slow Open - Is it normal for SSMS 2012 to take about 42 seconds to open on a workstation? Windows 7 Enterprise x64 Intel(R) Core(TM)...
Stored procedure running in loop is taking time to load . Is there any alternate way to run in a single execution ? - Hi All, I have an application where we will be showing the invoice and Plan backup reports for each recipient in...
TSQL - Return rows based on the value in another row - Hello, I hope someone may be able to help? I have table which holds relationship data where most of the relationships are...
?Logon to server '%Servername%' failed SQL Server issue) - Dear All, As said in subject i am getting Frequent Event Logs in my SQL Server fro
Data Driven Subscription Time Outs - Once a month on the first of the month I need to burst an SSRS report out to ~200 email...
Changing Domains and can't change service user - I am having a weird problem while testing a domain name change - I can't restore the encryption keys. The long story: We...
