Viewing 15 posts - 166 through 180 (of 694 total)
I always install all services on a prod box. And then run off all that are not needed. It is easier to turn on a service than it is to...
May 4, 2013 at 10:27 am
It would be much more simple to script the objects in SSMS and execute the script against the database that you want. Any and all databases that you want. When...
April 30, 2013 at 11:54 am
My question is this:
Why would you be using, or even have over 100 databases with all the exact same objects. This sounds like you have a database that is storing...
April 24, 2013 at 6:46 am
HI
It would be much more simple if you write a stored procedure, or create a DTS package that is executed from a SQL job on a daily basis. Then perform...
April 23, 2013 at 11:23 am
What tool? Redgate had a large collection of different pieces of software. Have to be more specific.
Andrew SQLDBA
April 18, 2013 at 3:05 pm
Most company policies have a strict guideline about keeping xp_cmshell turned off. Not allowing access to that from anything. Also, most companies never use the Program files group for storing...
April 10, 2013 at 10:45 am
That would surely cause issues in performance if I were to select "all events".
I just need to know if there is a way to show if a query is actually...
April 9, 2013 at 5:03 am
You should create another database and use that for all your development work. Set up a sql job that performs a backup and restores it over your development database. How...
April 1, 2013 at 9:05 am
SQL Server does not Loop thru rows. SQL Server is Set Based.
Please do not indicate that a database loops thru rows.
Andrew SQLDBA
April 1, 2013 at 8:43 am
Because that you can have more than one filegroup. And that tells SQL Server to create the object in a certain file group. Yes, it is required. That is, I...
April 1, 2013 at 6:17 am
You can put any of the user databases on the box into single user mode.
Why would you be developing against a production database? If needed, create a database on the...
March 31, 2013 at 6:01 pm
I like what BitBucket suggested. But stay far away from cursors. Remove that junk code and use efficient code.
Andrew SQLDBA
March 31, 2013 at 10:33 am
If this is something that the company uses to keep their business up and running, you cannot use an off the shelf, home user edition of the OS type of...
March 31, 2013 at 10:19 am
Why not get away from the old fashioned batch files, and use a simple SSIS package? That would be so much more simple, more efficient and much more secure. And...
March 30, 2013 at 5:04 am
Viewing 15 posts - 166 through 180 (of 694 total)