xp_cmdshell File Copy Failing - "Access Is Denied" - 2 New Windows Servers 2016 running SQL 2016 Standard. No Active Directory. Logged on as my local account (in Windows Administrator...
KILLED/ROLLBACK query doesn't stop running - I've tried to kill a query but it has the status killed/rollback ! the query is SELECT Id FROM dbo.Month WITH...
Hardening SQL Server - Hello everyone! Does anyone here hardening project of sql server? What major parts of this project and what is your recommendation? If you...
Query never completes with CXPACKET waits - Hi, I have a query that runs in under 40 minutes on our test server but never completes on the production...
Unexplained jump in Backup File - I hope somebody here can help with this one, it's driving me mad. Up until 1 week ago, our full daily...
Flipping between SIMPLE and FULL recovery mode - Hi, DBA's out there in the big wide world just need some insight I am a SQL Developer (DBA light) and...
Performance improves after reboot - I am an ETL Developer who was asked to look at SQL Server performance problem. We have two DBA's but they're...
SQL Server DBA training. - Hello everyone, I have a question about the SQL Server training. I have been working as a IT helpdesk for...
Help with Instead of Trigger - I wanted to Validate the code againt the look up table before i insert into a Base table. I have two...
trouble wit a poor performing query - I've got a poor performing query and not sure the best approach to fixing it. Here's the statement: UPDATE @t SET...
Why is restoring a system database cross server a bad idea? - Hi all, I made a post a while ago in regards to an update to our DR process we currently have....
What is perfect way to declare variable data type in asp.net to match SQL data type? - From asp.net project I need to insert data into one table in SQL server which has a lot of data...
Read multiple .sql files having issues with .cmd script :( - Hello, this is part 2/2 of my goal, so i have created a write part and it writes to a share...
Count Difference for Every 15 Min - Hi, When I run the query using mulitple joins on Fact table and Dimension Table, my Output would look like Execution :1 When...
How to break down time span in Categories - Basically I have list of the tickets (records) in the db table ticket, and I need to find how long...
High Memory Usage - In our production server , memory usage is around 95% even tho it has been capped (8 GB ) . Total memory 12...
Rename instance name in SQL Server 2008 R2 - How to rename a instance name, and let me know do we need to restart the server to be affected
Restore Database Question - Hello, My predecessor left this bit of code in an SSIS package and I can't understand how one restores a database...
Is having a lookup table that is for multiple entities a common practice? - I've been programming and designing databases of various sorts for several years. And I've been on teams who have designed...
FAQ: Using the new forum Software (Jan 2017) - After we completed the forum upgrade on Jan 12, 2017, quite a few things changed, so this thread is a...
