Merge Tables with SQL Query Request - Hello Community, Can someone please take a look at the following tables and let me know how to compile a sql...
SQL Server Job which downloads the files using Script Task fails after few runs on the Agent - I have an SSIS Package which uses a script task to download some zip files daily from websites. The Package is...
Queries to practice compilation and recompilation. - Hi expert, Can someone please post here some quires (or simulate recompilation) to practice compilation/recompilation? I would really appreciate. Thanks,
Decode waits on Object resource - Hello everyone, One of our servers is experiencing locks on particular objects of a production database, like for an example OBJECT: 7:480772820:27....
Looking to downgrade our SQL Server editions from Enterprise to Standard Edition - We're looking to downgrade our SQL Server editions from Enterprise to Standard. Contacted our vendors, they all signed off they...
Error: 15006 'username' not a valid name because ... - Dear I'm new to SQL and trying to learn the basic in a practical way. The error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Create...
Looping Through Data - Hello, I'm new to SQL. This is what I'm trying to do. If Caller and Call Type is same within the table...
Set @rptStartDate = CASE WHEN 'TransactionCount' = 2 Then '11/1/2018' - 30 days Else '11/1/2018' End - Hello again! The issue I am having today is dealing with a date change when certain conditions are met. As...
Error: Cannot insert duplicate key row in... a non-unique index?! - Cannot insert duplicate key row in object 'Payment' with unique index 'IX_Payment_PurchaseId'. The duplicate key value is (2999, C1234, 2018-12-13,...
Text data type - Is it still supported by SS 2016? Thanks
Run away logical reads on stored proc causing timeouts. - Hi, I am hoping some one maybe have any insight or suggestions. I have a stored proc that returns 10 to 200...
Find the root cause of SQL Server slowness and possibly killing blockers automatically - Hi, we have noticed this morning around 9:30 AM EST that our applications became unresponsive. we started getting emails from SQL...
PERCENTILE_DISC for median calculation - Question: is PERCENTILE_DISC for median calculation works for both odd and even number of records? In SQL Server 2008 to calculate...
WHERE 1 = 1 - I am afraid I am really going to show my newbie-ness with this question … I see lots of stored procedures...
SSIS from Premise to Azure connection login timeout - I setup a nightly job to load data from a database on premise to Azure. The SSIS runs successfully intermittently, but sometime it...
Problem reading all Attributes into SQL table - Hello everyone. I'm writing a proc that imports several XML files and stores them in a SQL table. Here's a sample...
QueryStore practical everyday use - Hi We have been using QueryStore since day 1 of our SQLServer 2016 installation For every day usage though, the standard...
Date Format (mm/dd/yyyy hh:mm), no seconds or milliseconds - Does anyone know syntax to use to format a date field with as follows (02/09/2009 14:34)? Any help would be appreciated. Thanks, Jeff
I/O error 170(The requested resource is in use.) - Hi all I have some problems with one environment.. It was a virtual cluster active/passive with 2 virtual nodes and virtual disk...
T-SQL code to group data into comma delimited column - hi All, I have a view v_Newsletter with has two columns email and newsletter. There are some emails which has subscribed...
