Viewing 15 posts - 1 through 15 (of 197 total)
As Gail indicated, that's a pretty large topic to cover without more details about what it is you're after. In my humble opinion, Kimberly Tripp is the reigning expert at...
November 9, 2013 at 12:05 pm
kreierson (11/8/2013)
Thanks for your reply. I am very new at trying to decipher execution plans, so if you had any recommendations on a good website or book it would be...
November 8, 2013 at 9:31 am
If you are planning on running it as a scheduled job, I would recommend checking to make sure the database is online before you take it offline. Something similar to...
November 7, 2013 at 10:29 am
Thanks Jeffrey, I was pretty sure I was going to have to go down the uninstall, re-install path. So I guess I'll just handle it the same way I would...
November 5, 2013 at 1:30 pm
GilaMonster (11/4/2013)
kevaburg (11/4/2013)
Just to clarify.....In SIMPLE recovery mode, transactions are cleared once they are committed,
In simple recovery, the log is marked reusable by a checkpoint, not a commit. That's assuming...
November 4, 2013 at 7:33 am
If you have the default trace enabled, you should be able to query it to find out when your transaction log is growing. From that, hopefully you can identify any...
November 2, 2013 at 9:55 am
Simple recovery allows the log file to be cleared of transactions without having to take a backup of the transaction log. Regardless, it will still grow if something requires that...
November 2, 2013 at 9:47 am
I'd also recommend you take a look through "SQL Server Transaction Log Management" by Tony Davis and Gail Shaw.
You can obtain an electronic copy of the book from this site:...
October 23, 2013 at 10:36 am
New persopn (10/22/2013)
How can i check whether how many virtual log files in log
Check out the following blog as well as the "'8 Steps to better transaction log throughput" link...
October 22, 2013 at 7:32 am
Didn't they remove the reverse engineering in a recent version of Visio?
Yes, I believe it was removed in Visio 2013.
October 21, 2013 at 2:03 pm
You'll have to install the appropriate MySQL ODBC driver on your SQL Server first.
Here's a snippet of a linked server creation script to give you an idea of how it's...
October 21, 2013 at 1:49 pm
hjvegt1960 (10/21/2013)
Hi allThese extensions are tablename.FRM, tablename.MYD and tablename.MYI. Maybe this rings a bell for some.
These are MySQL database files. The .FRM is the table structure, the .MYD is the...
October 21, 2013 at 1:32 pm
Ed Wagner (10/18/2013)
tabinsc (10/18/2013)
Victor Kirkpatrick (10/18/2013)
Might be an easy one, but I learned something: the WITH VALUES clause. Thanks.Same here
Same for me.
Same here, wasn't familiar with the WITH VALUES clause.
October 18, 2013 at 6:52 am
mishrakanchan86 (10/15/2013)
the 100 table make about 100 GB. This is what I am planning to do.
Step 1....
October 16, 2013 at 8:18 am
mishrakanchan86 (10/15/2013)
I have around 100 tables to copy from one server to another. The problem is that these 2 servers are not in the same network. Is there any...
October 15, 2013 at 8:34 am
Viewing 15 posts - 1 through 15 (of 197 total)