Implications of slower writes with 64K pages using SSDs vs SAN - As part of our migration to SQL Server 2017, we are considering a move to local SSDs. Some testing with...
Indexing Issue - Hi, I have the following temp table listed below. In the interface we created the user has the option to enter in...
Shared stored procedure with very complicated input - So, the basics of what I want to accomplish is simple...I have a stored procedure that has some really complex...
Delete syntax not working - hi, Here is the delete syntax but it is not working even though all the conditions satisfy. What is the issue? DELETE...
can I put more than one database per disk? - Actually I have one database disk C : OS disk D: tempDB disk E : MDF fie disk F : Ldf file disk G : Backup disk now I have to create...
A way to restaure backup skipping some filegroups... - Hello, A have to restaure a huge database (PROD) on a smaller environment (STAGE). My database is split in filegroups, I...
Using Extended Events to alert on long running queries - Hi Is there a way with Extended Events, where I can set up something; should a user/developer run a query via...
Doing multiple updates with an ADODB Connection - This working code lets the user enter something in a cell, click a button in Excel and exports the data...
Modifying my parameterized query to select * an entire column - This working code lets the user use a click event in Excel/VBA to separately insert values into the same field...
Delete Server in DB Engine - Hello, I have two different instances of database engine on local servers. How do I delete one? Thanks
CASE statement and inner join giving duplicates - Dear DBAs I am using a CTE to get terminal locations from one table and then joining this CTE with...
Move user database - Why is detach/attach not recommended for moving a user database?
Query to give sum of items with condition from multiple tables - I have these tables: LineItemSubParts, CostCodeSubCategories, CostCodes and LineItems In the LineItemSubParts table there are fields named Quantity, MQuantity and Cost In the CostCodes...
Running Balance query - I have a Transaction table having the structure as follows: DECLARE @Transtable TABLE( ID INT IDENTITY(1,1) NOT NULL, DATE DATETIME,...
S?QL Server using 97% of RAM. - Good Morning Experts, SQL Server is using 97% of RAM. Could you please advise what needs to be done.
Date Search - Hi, I have in a data row: column 2017-11-06 01:17:34.000 I only want to search for values if the year is...
Log shipped db in suspect mode - Hi, I have a log shipped database on SQL 2008R2 that last night went into suspect mode & I cannot run checkdb...
Sum for year within Tablix - Hi I have a report that I am trying to do that is filtered by what period the user enters....
What URL should I give to run the report directly.. - Question: I am trying to get a report to run immediately. What I mean is if I paste the following...
Hard going back... - Is it just me, or once you've used SQL Server, is using Access again (especially for reasonably complex queries) just...
