Viewing 15 posts - 45,676 through 45,690 (of 49,552 total)
Steve Jones - Editor (7/15/2008)
The prerequisites make some sense, but it needs to have some way to verify those items and test the skills.
Since it's training courses and lab...
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
July 15, 2008 at 11:12 am
There's no magical quick-fix for performance problems. You are going to have to find the poorly performing queries (run profiler for an hour or so and catch all the queries...
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
July 15, 2008 at 10:59 am
What recovery model is your database in?
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
July 15, 2008 at 7:56 am
The concatenation problem I'll leave for someone else. As for the perf problem...
The functions you have on the column in the where clause prevent index seeks, so the query requires...
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
July 15, 2008 at 7:51 am
Specifying WITH RECOVERY recovers the database and brings it online. Once recovered, no more log backups can be applied (which is why you only want it specified on the last)
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
July 15, 2008 at 7:49 am
Then someone's running a proc/sql batch on the other server that's checking your statistics.
Have a look at the server that's the source of this. See what you can see running
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
July 15, 2008 at 7:47 am
Reindex alone should be fine. Reindex updates the statistics so there's no need to do that as a separate step
Don't shrink your databases
Don't truncate your logs. Either set up a...
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
July 15, 2008 at 7:45 am
rinu philip (7/15/2008)
I have tried it on sql 2000.:) and it worked..
I thnk that's an ODBC function, rather than native SQL. Can't find a confirmation though.
Either way, there's no associated...
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
July 15, 2008 at 6:26 am
DBCC SQLPERF(logspace) will show you the percentage log space used for all the database on the server
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
July 15, 2008 at 6:16 am
rinu philip (7/15/2008)
SELECT ENCRYPT ('Test')-> when this select query is run on a database the value obtained is in an encrypted format.
On which version of SQL? On SQL 2005,...
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
July 15, 2008 at 6:13 am
HanShi (7/15/2008)
Keep in mind that the results are reset whenever the SQL-service is restarted.
Entries disappear from the query_stats DMV when the query plan is discarded from the plan cache. Depending...
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
July 15, 2008 at 6:06 am
Create a permanent numbers table with a couple thousand rows. It's handy for a number of problems, not just this one.
Somethng like this
CREATE TABLE Numbers (
Number INT PRIMARY KEY
)
GO
INSERT INTO...
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
July 15, 2008 at 5:53 am
rinu philip (7/15/2008)
My questions are1) where is this backup stored? (I mean BACKUP LOG)
It's not.
2) what is truncate_only? (does it only truncate the log files?)
Discard the inactive portion of...
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
July 15, 2008 at 5:43 am
Easy way to check - once you've done the restart, check the first few lines of the error log and see if you have the entry "Using locked pages for...
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
July 15, 2008 at 5:36 am
kiruba (7/15/2008)
Thanks SSCarpal Tunnel
<grin> That's the forum ranking, not username.
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
July 15, 2008 at 5:20 am
Viewing 15 posts - 45,676 through 45,690 (of 49,552 total)