Forum Replies Created
Viewing 15 posts - 1 through 15 (of 29 total)
-
RE: Client tools Licensing?
How about if you are running a per CAL license on the server and not a per Processor license? You would need a CAL for every workstation accessing the SQL...
-
RE: Error when creating sp_hexadecial and sp_help_revlogin
Probably not enough. 
-
RE: Error when creating sp_hexadecial and sp_help_revlogin
In looking at it further, I believe you may be correct. I think I was looking at it too long.
-
RE: Error when creating sp_hexadecial and sp_help_revlogin
It looks the same on my servers. If I was to try something it looks like you are missing OUTPUT on your first @binvalue. You have one for your @hexvalue but...
-
RE: T-SQL basic Query
Great to hear! So many times I hear of data, logs and even backups on the same drives. Makes me cringe!!!
-
RE: T-SQL basic Query
Mark,
You say "I would like to find out the physical location of both the .mdf & .ldf files as tehy would appear to have been installed on different drives. So,...
-
RE: File Comparison
It would basically work something like this...
SELECT U1.*INTO N1FROM U1LEFT OUTER JOIN B1 ON U1.field = B1.fieldRE: TLOG backup vs full database backup
Just to answer your last question, a full db backup will not truncate the log. You need to do a tlog backup to truncate the inactive portion of the log.
RE: moving databases?
John,
What you propose would work just fine. When I am in this situation, I find it easier and quicker to stop SQL and copy the data and log files to...
RE: Problem about indexes
I think this will answer your question...
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=14052
Good luck.
RE: Question of the Day for 01 Mar 2006
Ditto.
0.8414709848078965
RE: SQL Server Disk configuration
I agree that I would rather have separate logical partitions of the 72 GB drive. That way you are only concerned with SQL Server on the other partition and can...
RE: Suggestions?
I agree with Sameer. You usually want to do this as a last resort. You need to manage the growth of the log on a daily basis, so this does...
RE: Deadlock
You could try enabling certain trace flags 1204 and 1205. These have helped me identify the cause when I have a deadlock problem.
This link may help... http://www.sql-server-performance.com/ac_2000_trace_flags.asp
RE: Suggestions?
There is probably an uncommitted transaction in it. I don't know of a way to look into the log without using a third party product like Log Explorer. I think...
Viewing 15 posts - 1 through 15 (of 29 total)