Viewing 15 posts - 36,271 through 36,285 (of 49,552 total)
bcp is only necessary when you have irreparable corruption and no clean backups. The best way to recover from corruption (depending on the severity) is to restore a clean backup.
Take...
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
October 16, 2009 at 1:01 am
Does the table applicant have a column named intakeid?
p.s. do you realise you have a cross join here?
FROM applicant a,program p
That will return a Cartesian product of the rows 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
October 16, 2009 at 1:00 am
San-847017 (10/15/2009)
If you leave out either step 1 or step 3, the DB will be suspect when it's brought online.
Gila, Infact it's not coming online at all. Getting the error...
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
October 16, 2009 at 12:50 am
Ninja's_RGR'us (10/15/2009)
GilaMonster (10/15/2009)
Ninja's_RGR'us (10/15/2009)
We I mean slowly I mean 10 seconds to record 1 record on a "supposed" index seek, his words not mine.
Can you find/get vendor to find 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
October 16, 2009 at 12:44 am
jordon.shaw (10/15/2009)
How do I make this add 1 to ASSETINDEX for each record using the insert statement the way y'all have suggested?
Make the column identity and let SQL handle it....
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
October 15, 2009 at 4:17 pm
Or you can take a substring.
Look up LEFT and SUBSTRING in SQL's books online.
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
October 15, 2009 at 3:53 pm
Elliott W (10/15/2009)
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
October 15, 2009 at 3:48 pm
Fraggle-805517 (10/15/2009)
Any thoughts on how to go about figuring out what is causing those?
Sub-optimal queries
Poor row estimates by the optimiser.
Use sys.dm_exec_requests to look for queries prone to CXPacket waits...
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
October 15, 2009 at 3:40 pm
Fraggle-805517 (10/15/2009)
The ol' magic 8 ball.
So 8 processor cores? No hyperthreading?
7,086,376.171/8 = 885422.02 -- wait time is cumulative over all processors, so divide by 8 to get actual 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
October 15, 2009 at 3:32 pm
Bill Mosca (10/15/2009)
I guess you can't backup a log without having at least one full backup.
No you can't. Until a full backup is taken, the log is auto-truncated on checkpoint...
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
October 15, 2009 at 3:16 pm
jordon.shaw (10/15/2009)
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
October 15, 2009 at 3:06 pm
Edit: hit post too early. Working .....
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
October 15, 2009 at 2:59 pm
Ninja's_RGR'us (10/15/2009)
We I mean slowly I mean 10 seconds to record 1 record on a "supposed" index seek, his words not mine.
Can you find/get vendor to find the wait type...
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
October 15, 2009 at 2:55 pm
chk2009 (10/15/2009)
Thanks for your reply, yes I want to reduce cpu usage, I believe SQL server is taking more memory.
Find the queries that are using all the CPU. Optimise them....
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
October 15, 2009 at 10:05 am
SQL 2005 or SQL 2000?
Check the maint plan history, check the SQL error logs.
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
October 15, 2009 at 9:53 am
Viewing 15 posts - 36,271 through 36,285 (of 49,552 total)