Topics
Started by
Posts
Last post
How to optimise the following query, it's doing a Clustered Index Scan (Clustered). select doc…
9 replies
We're re-examining our database server security architecture, as we are starting to migrate our old…
2 replies
We're looking at one of those for tempdb. I believe tempdb is good with 8 30GB data files ( all sa…
16 replies
I can't figure out why my attempt to compile an SP on "database1, server2" is failing when it's not…
5 replies
Hello experts, I am helping developers troubleshoot a PHP error they are seeing in a scheduled job.…
1 replies
Select * FROM tableA where desc like 'Unknown%'; How do I modify this so that I get only hits that…
6 replies
Hi all I have database that is set with log shipping to another secondary database. Also have a tes…
6 replies
Hi All Does anyone know of a way to preserve the users, assigned DB roles, owned schemas etc of a d…
3 replies
Hi all, We have a large number of SSISDB packages running happily, connecting to our SQL Servers us…
3 replies
So I setup the Management Data Warehouse on a performance testing environment for our company. My f…
1 replies
Hi, I am working to store the job output. I need an idea I have a sql job with 12 steps. If it fail…
6 replies
I'm looking for articles on Partitioning a Table by year. I have read several and executed the code…
17 replies
Hi We currently have log shipping set up. Our database ldf log files are currently on Drive D along…
4 replies
Afternoon, I've been running an extended event session to capture rpc_completed events on one of my…
2 replies
So I have a SQL2012 server where I have used SQL Configuration Manager to disable Named Pipes as us…
9 replies
Viewing 15 topics - 3,391 through 3,405 (of 8,636 total)
You must be logged in to create new topics.