RE: backup question
In a heavy load, having two log files, perhaps on two disks, can help performance.
2005-01-28
Migration
RE: How many platforms Do You Run at Home
3 Desktops running Windows XP1 Desktop running some Windows version I don't remember offhand1 PDA running Windows PocketPC1 Handheld running Windows CE1 server running Debian Linux
2005-01-25
Script of the day (1/4/2005) - Get the Value of a BitMask
I find it interesting that the the translation from bit map to decimal number is done left to right and not right to left. This not the convention I expected.For example'0' = 0'1' = 1'01' = 2'11' = 3'001' = 4 I guess I expected '0' = 0'1' = 1'10' = 2'11' = 3'100' = 4 Is […]
2005-01-04
6 reads
RE: HUGE Log File
Really the quickest way?Detach the db, rename or delete the log, attach the DB or useBACKUP LOG WITH TRUNCATE_ONLYDBCC SHRINKFILEBtw, changing the recovery mode has not much to do with the growth of the log file. In doing so, you give up your ability to restore to the point of failure or a point in time.
2004-12-29
Suggestions forum suggestion
Circular logic????Anyway, the "SQL Server Newbies" forum has a "sticky" post that alway stays at the top, "Beginning Administration". Perhaps this forum could use one explaining its purpose, possibly preventing SQL questions from being posted here where they may not be answered promptly!?!Steve
2004-12-27
How to generate SQL DML
I have this peculiar request. We have a library which all developers use to connect to the Production databases. During the course of their interaction with the DB, any Update or Delete statement requires me to take the current state of the Row(s) based on the where clause from the Update/Delete statement and generate all […]
2004-12-07
1 reads
Analysis Services Taining
Anyone have any suggestions on where to get some decent training on Analysis Services. I am fairly new to SQL, and I need to make better use of our Data warehouse. On-line or not!
2004-11-01
Database recovery
Hi,I have a customer with the following problem. He has a SQL 2000 server on a box with a RAID 5 controller. For some reason, he has not been properly backing up his database, but he has been doing a system wide file backup of his disk with Backup Exec. His RAID controller recently failed. Having replaced the […]
2004-09-07
2 reads
RE: Finding EM diagram name by the name of the table which is included in it
The table names are in the dtproperties table, but they're hard to get at.This is a crude attempt. I tried to filter out the table names, but sometimes they have an extra garbage character as a prefix. This code assumes that all table names are made up of regular ASCII characters, and that all dtproperties tables in […]
2004-09-02
RE: A tale of two where clauses...
It always annoys me when I see a newsgroup thread somewhere about a problem I am having, and the conversation stops before the problem is found or the resolution is posted. I will say that I recieved much better support and ideas from this forum than the MSDN Managed discussion groups. Thanks for trying everyone!
2004-08-20
Blogs
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers