Need VM for practice - Hi, A question for DBA's. If I cannot find Sand Boxes in our environment for some reason, is there a...
Count of values in column - Hi Friends, I'm a newbie. But I was wondering if i had an employee table joined with a department table with a...
Diagscan Tool - Hello Where to get the Diagscan Tool? This is another useful tool like Nexus. Kindly advise how to get it
SSRS 2016 - HTML5 rendering issues - Hello, We migrate reports from a SSRS2012 Instance with Sharepoint integration to a SSRS2016 Instance in native mode and we encounter...
query performance - Hi, I have this execution plan and a query which run more than 10 h.Please help me with some performance tuning recommendations. UPDATE h
DelimitedSplit8k and Performance - I am working on taking data out of an ERP system and into a data warehouse. One of the unfortunate...
Excessive Paging Continues... - We've been experiencing "excessive paging" for a while (per perfmon review). Application is sluggish. Added memory to the server (virtual machine), there's...
The transaction log for database 'database_name' is full due to 'XTP_CHECKPOINT' - Hi Gurus, I'm new to SQL Server. We got an issue on our Production Server at this moment and i'm having...
Joining a large table to itself....better ideas? - Hello all, I'm creating a view to use for future queries to make things easier. Essentially this view needs to join...
SSRS Grouping Problem - I have a report that has a dataset problem that I'm not sure I can fix. The query for it...
Auditing copy/paste from a spreadsheet - I have been asked to audit users who are pasting data into a table by right-clicking it, and choosing "Edit...
High CPU during specific timings - Hi All One of our critical database servers is facing high CPU utilization during a particular time every weekend . I try...
Help needed on TSQL query: update using a self join - Hi Experts, Need help on an update query. I want to take all status = 'IN' records qty values and update those...
Return last amount larger than 0 - Hi guys, I have a table of accounts by month. I need to return the last amount larger than 0 e.g Unique_ID DATE CLOSING_CREDITS CLOSING_DEBITS 00522467364634 2017-03-01 0 ...
carving out bussiness hours. - so i'm newish to SQL and SSRS but i'm working on a report that allows me to calculate average times...
The transient database snapshot for database 'DB1' (database ID 5) has been marked suspect due to an IO operation failure. - I have looked all over google regarding 'snapshots' in SQL 2008 and I have been reading up on their function...
SQL server 2008 R2 frequent transaction log full and my database is a mirrored one. - I have 1 pair of identical server with SQL server 2008 R2 is installed.I have 2 databases in it which...
Using a Temporary Table in SSRS - Hello, I have created a temporary table in SQL Server Management Studio.. I want to use in in SSRS so...
Taking backup with option "Disk = nul" - hi , can anybody tell me what exactly below backup query does ? and where it keep the backup file after taking...
SSIS Package Error - VS_ISBroken - Hi, I'm using the following : SQLServer 2005 SSIS Version 9.00.4035.00 I have a data flow task within an existing SSIS pkg....
