Sql 2017/2019 unattended installs tempdb files - Trying to verify that what I am seeing is intended behavior not something I have messed up. When installing 2017...
blocking for same query on user DB - Hello Gurus, In Production I noticed one issue and need your help. On the web page when we click on a...
SQL Quiz - Here's the challenge: Let's say we had a table of all US Presidents, with the date they took office and...
Lack of clustered index generally a good idea? - https://use-the-index-luke.com/blog/2014-01/unreasonable-defaults-primary-key-clustering-key This is my first exposure to this concept. What is you guys' take on this? It sounds like it MAY...
DT_BYTE to DT_DBDATE - I've got an SSIS project pulling data from a MySQL database into SQL Server. One of the date values in the...
Long Running Processes - I am looking for a query to find and kill long running processes...Now i know i will get a lot...
Index rebuild issues - I have just started at a company that has an existing ERP system and they are some pretty bad performance...
sql server 2016/2017 books etc. - Is there a good book or material to learn the product from a DBA perspective. I will probably take the...
Assigning results of stored procedure with parameter to variable - Hi all We've got a stored procedure that gives a list of email addresses based on a parameter and we want...
adding each row incremental - Hello, sadly i am at my witts end with this complicated problem, and i know you guys are smart than i...
Case when inside of partition by? - Hi, I have the following situation: CREATE TABLE #TAB1( ID INT ,MY_STATE VARCHAR(10) ,EVENT_TS DATETIME ) INSERT INTO #TAB1(ID, MY_STATE, EVENT_TS) VALUES (1, 'STATE_1', GETDATE()) ...
Left Join with View taking more time in SQL Server - The below query is taking twenty seconds to display 53,000 records. This query has five left joins with views. But...
Return data even if no record present - Hi all, I have table called students, and I would get record even if data is not present for a...
Values are randomly set to NULL - Hi! I have a table with some encrypted values. It has in total 85 rows, and over the weeend, some of the...
Clustered Index Scan vs Seek - Hi, I have a table with an Id field. It is NOT auto increment. Every time we insert the new rows,...
Two column body - Forgive my ignorance as it has been several years since I have built a report in SSRS. I have a...
My subreport only shows 1 record, even when there are more. Why? - I've got a main report, which is a detail report. And a smaller report, that's used by the main report...
Import specific rows from Excel - Hello, I'll get right to it... I'm trying to schedule a package to pull data from a shared Excel source (which...
SSIS - Error: Failed to acquire connection - A situation caused an error. I need to fix that. Error - Error: Failed to acquire connection "MyDBConnection". Connection...
I/O error 23(Data error (cyclic redundancy check) - I have encountered the below error message when i try to do sql query. Server: Msg 823, Level 24, State 2,...
