Viewing 15 posts - 11,011 through 11,025 (of 14,953 total)
Unless all your code is written without schema names in queries, updates, etc., you'll need to do far more than just rename them all.
I don't think there's a way to...
February 10, 2009 at 3:32 pm
If the point-in-time selected is in log file 5, then yeah, it would be usual. It finishes at that point, and doesn't need to go any further, so it's...
February 10, 2009 at 3:25 pm
gints.plivna (2/10/2009)
GSquared (2/10/2009)
If I were interviewing and found that the prospective employer expected me to use a command-line interface to the server as my only tool, I'd tell them the...
February 10, 2009 at 3:23 pm
There are backup history tables in msdb that you can use to build an automatic PIT restore script. Since they have the backup time in them, as well as...
February 10, 2009 at 3:09 pm
Not at all like arguing religion. For this one, you can create very precise metrics.
Run the database with auto-update turned on for a few weeks, have a trace running...
February 10, 2009 at 3:01 pm
Are you familiar with "Group By" and "Count"?
February 10, 2009 at 2:58 pm
gints.plivna (2/10/2009)
February 10, 2009 at 2:57 pm
The cost of SQL Compare can be rolled into the savings of SQL Server vs Oracle. Very, very easily rolled into that.
Edit: Just checked pricing on Standard Edition for...
February 10, 2009 at 2:01 pm
Greg Edwards (2/10/2009)
Or for a surgeon...
"I accidently removed the wrong limb, what should I do?"
I can remember having to write "No" on my left shoulder before going in for surgery...
February 10, 2009 at 1:57 pm
jagadish_sds (2/10/2009)
I read in some blog that Stored procedure execute faster than trigger.
That statement happens to be incorrect, assuming both use the same code.
You can prove this by using "set...
February 10, 2009 at 1:44 pm
Bruce W Cassidy (2/10/2009)
"Urgent! Urgent! Urgent! I have someone in my office...
February 10, 2009 at 1:30 pm
To add to what Bob wrote, harming the organization harms their customers and employees as well. I find it difficult to get personally worked up about harming an organization...
February 10, 2009 at 1:18 pm
The default for the query attachment is to just have a blank space between the columns. One blank space. Just because you use the ".csv" file extension doesn't...
February 10, 2009 at 1:13 pm
The way I handle that kind of chain is keep the set of tables that might have a "broken chain" in a derived table (I use CTEs for it now...
February 10, 2009 at 1:05 pm
Viewing 15 posts - 11,011 through 11,025 (of 14,953 total)