Viewing 15 posts - 38,911 through 38,925 (of 49,571 total)
There's still two addresses and two phone numbers in the table. That could (or could not) be construed as repeating groups.
If it is considered a repeating group, this isn't even...
May 26, 2009 at 1:32 pm
middletree (5/26/2009)
So if I back up the lgos regularly, it will make the logs smaller?
More correct to say, if you backup the logs frequently the log shouldn't grow. A backup...
May 26, 2009 at 1:26 pm
What mode did you specify? If the mode is limited (which is the default) then quite a few of the columns will be null because the leaf pages of the...
May 26, 2009 at 1:07 pm
What you could try is to put the tables that you don't care about into a different database and set it to simple recovery. Doesn't stop logging, but tran log...
May 26, 2009 at 12:27 pm
homebrew01 (5/26/2009)
Would adding a new field at the end of a table cause locking ?
Yes. Adding a column will take a schema modification lock, which is incompatible with...
May 26, 2009 at 12:13 pm
now make sure that you set up a job to run regular log backups. Otherwise this is just going to happen again.
May 26, 2009 at 12:11 pm
Operating system error 5 is "Access denied"
Check the folder and the log file, make sure that the SQL Service account has full permissions on the file.
May 26, 2009 at 12:10 pm
Roy Ernest (5/26/2009)
Hey, How are you all getting on to the site? The only page that works for me is this. Rest of them gives me a zonal error. 🙁
http://www.sqlservercentral.com/Forums/Topic723332-433-1.aspx
Someone...
May 26, 2009 at 10:02 am
Is it first normal form?
The requirement for being first normal forum is that there are no repeating groups. If we take the addresses as repeating groups, then this isn't even...
May 26, 2009 at 9:31 am
I guess my first question here would be whether you'll need all the addresses every time that you query the users table, or will you need them only a small...
May 26, 2009 at 8:27 am
george sibbald (5/26/2009)
worth a ping to steve, thanks a lot Gailseems a bit fishy to me (and you can spell that with a ph too)
Turns out to be a bit...
May 26, 2009 at 8:20 am
da.drew (5/26/2009)
I was informed that by selecting the DB it would go to the right one, clearly not true!
Definitely not true.
The DB selected in object explorer is not related...
May 26, 2009 at 7:41 am
select MyColumn
from MyTable
order by REPLACE(MyColumn,'(','')
May 26, 2009 at 7:38 am
Lowell (5/26/2009)
TWill changing my clustered index to include those columns, instead of the exisitng identity() column, assist the query performance wise?
A clustered index has the data page at it's...
May 26, 2009 at 7:32 am
Viewing 15 posts - 38,911 through 38,925 (of 49,571 total)