Hi there. I have a stored procedure that collects data modified in the past day. This is put into a temp table. Then a while (1=1) loop is...
Good day everyone. I once again need advice on, what is to me a very irritating change request. We have the current scenario: We have a value (let's...
Hi there, all. I have written a stored procedure that merges table from one table into another table. As input parameters it accepts...
Hi there. all. I've been assigned a change request asking me to add a bit field to a few views but only to the views. My question is if this field...
Hi there all I am wondering if someone could help me or perhaps point me in the right direction. My manager gave me a script where it compares...
Hi there all. I have a question again, this time regarding creating a script(s) that could be used throughout all servers. We want a script that...
I have a really stupid question to ask. My manager needs to know the minimum permissions required for a user to be able to backup the database. He...
Hi there all. I have a problem with an update statement. The error we're getting starts with "UPDATE is not allowed because the statement updates...
Hi there all. I've been tasked with writing a script where I iterate through sys.sysdatabases to find all databases with a compatibility level not...
Hi there. I need some advice, pleaseeeee. I restored a backup of a database called RedworldArchive from our production server to one of our other...
Hi there all. I've been approached by someone who needs some assistance with a query. Currently the query looks like this:SELECT...
Hi there all. Trust you're all doing well. I have about 47 odd million rows that I have to migrate from one table to another. I use the code below...
Hi there. I've been tasked next with partitioning two very big tables. I've create a filegroup, added a file, create the partition function and...
Hi there all. I hope you can help me. AGAIN. I've been tasked with finding a security solution for two of our key servers. On at least two of the...
Good day, everyone! I have a question regarding a newly created non-clustered, non-unique index I created on a table. Is this newly created index...
Hi there. I have one more question. Is there any way you can find out which database file a table is in?
Good day all. Hope all is well. I have a strange question or two. My manager asked me to gather him some information regarding the best...
Hi there people! I just want to find out if you guys can help me or perhaps steer me in the right direction. I'm currently purely a database...
Good mornig all. I trust everyone's doing well. I have a question or rather want to confirm something. Am I correct in saying the only proper DR...
Good day. I hope everyone's doing well. I have another annoying question. A colleague of mine wants to know if there's a script / way that he could...
Separate names with a comma.
