Viewing 15 posts - 2,206 through 2,220 (of 2,840 total)
Ah from New Zealand you are.
Tomorrow is a big day for India and New Zealand at Hamilton. What a day it will be. 🙂
March 16, 2009 at 2:40 pm
lmu92 (3/16/2009)
Maybe he's not interested anymore.
Or...
March 16, 2009 at 1:45 pm
Setting up DB back up should not be a big problem. So start there.
What you will need to do is to get their trust and to show that you...
March 16, 2009 at 10:46 am
Put a Square bracket around the column INDEX in the select statement
INDEX is a Keyword in SQL. So you do a select as
Select col1, col2, col3, [INDEX] from dbo.view
where...
March 16, 2009 at 9:19 am
What would happen is that if there are any users or roles in your DB that has Select update insert and delete permission on this table, you will have to...
March 16, 2009 at 9:15 am
Maybe Fox should just stop using Database and start using flat files. That should solve his issues. 😀
Just kidding.... Fox, You should try to learn how to write efficient T-SQL....
March 16, 2009 at 8:52 am
Fox, You actually use a cursor for that kind of operation??? :crazy:
March 13, 2009 at 8:40 pm
Hi Steve, I have a question for you. I tried to read the article " Is not encrypting personal info worth the risk?". Is it not hosted by SSC itself?...
March 13, 2009 at 3:17 pm
Do you have any Jobs, Scheduled tasks or something running that connects to that DB?
March 13, 2009 at 1:54 pm
Yea, that is a max someone set up. I am not sure for what. Usually the default is Unrestricted growth if I am not mistaken.
This is not production right? If...
March 13, 2009 at 12:34 pm
The NOT FOR REPLICATION is put when you create the table in the publisher. This is a valid configuration.
As per BOL NOT FOR REPLICATION is used in
Foreign key constraints
The...
March 13, 2009 at 11:19 am
Log files will grow when you snapshot is being done, But to this extent? I gig DB with a 45 gig Transaction log growth is certainly out of the ordinary....
March 13, 2009 at 11:14 am
Steve Jones - Editor (3/13/2009)
March 13, 2009 at 9:06 am
I liked Steves answer to the OPs post asking for info about Clustered Index and fragmentation.. 🙂
March 13, 2009 at 8:44 am
Viewing 15 posts - 2,206 through 2,220 (of 2,840 total)