Viewing 15 posts - 46,606 through 46,620 (of 49,552 total)
Once a week, reorganise an index if logical fragmentation < 30%, rebuild if fragmentation > 30%
Don't do both to the same index. It's redundant
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2008 at 4:16 am
GRANT ALTER ANY USER ON Database1 TO User1
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2008 at 3:15 am
Could you possibly post it as a create table please? I want to have a test table to try the query out on, and it's going to take too long...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2008 at 2:43 am
That depends on why the database is suspect.
Please take a look at the SQL error log. See if you can find anyy message indicating why the DB has been marked...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2008 at 1:58 am
magarity kerns (5/9/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2008 at 1:21 am
Checkpoint is a processes within SQL that writes all dirty data pages to disk. It's an automatic process.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2008 at 1:18 am
Varchar(25) at minimum, or you risk losing part or all of the time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2008 at 1:16 am
Duplicate post:
http://www.sqlservercentral.com/Forums/Topic498211-146-1.aspx
Please don't cross post. It just wastes people's time answering questions that hav already been answered elsewhere.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2008 at 1:01 am
It might be. Hard to say for sure. Give it a try and see.
What indexes do you have on those tables? How many rows does the query return?
Can you post...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2008 at 12:54 am
Don't ever let an application use sa to connect. There's no way to prevent someone who knows the sa password from doing anything to the server.
Set up an user name...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2008 at 12:50 am
Please don't cross post. It just waste people's time and fragments replies. Many people here read all the forums
No replies to this thread plese. Direct replies to the following thread
http://www.sqlservercentral.com/Forums/Topic498549-8-1.aspxthanks.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2008 at 12:48 am
There's no quick-fix silver bullet for SQL injection.
I would recommend you implement some logging, either from the app or from SQL to see exactly what commands come from the app...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2008 at 12:46 am
I'll have a go at something for you a bit later. Can you post the schema of the tables please?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2008 at 12:44 am
You will need both of the backup files to restore, since the backup will be stripped across the 2. Make sure you don't lose one of thse files.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2008 at 12:36 am
Ok, so if we look at your Gatwick - Amsterdam lines. They differ in the DEP_DATE and the RtnDEP_DATE. Those two columns are included in the group by. Hence the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 9, 2008 at 7:41 am
Viewing 15 posts - 46,606 through 46,620 (of 49,552 total)