Viewing 15 posts - 24,271 through 24,285 (of 49,552 total)
shank-130731 (8/10/2011)
DECLARE @ETD datetime
SET @ETD = '2011'
SELECT ETD
FROM IXT_OceanShipments
WHERE (ETD >= @ETD)
ORDER BY ETD
As predicted by Jeff, I ran into problems as we increased records. Formalities: SQL2005. ETD is formatted...
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
August 10, 2011 at 8:46 am
Lavanyasri (8/10/2011)
HI Gila,please reply to mail pleaseee
I don't answer questions via mail (unless you're a paying client) Besides, I had no mail from you.
As for recommendation:
Suresh B. (8/10/2011)
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
August 10, 2011 at 8:43 am
What's server max memory set at?
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
August 10, 2011 at 1:07 am
If the database was shut down cleanly (probably not) then SQL will recreate the log on startup.
If not, the database will come up in recovery_pending then you'll have to use...
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
August 10, 2011 at 12:54 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1157392-148-1.aspx
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
August 10, 2011 at 12:53 am
errr It Depends (on what I'm trying to do)
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
August 9, 2011 at 5:08 pm
Leo.Miller (8/9/2011)
Be carfull of using sp_spaceused. If your statistics are out of date, the table sizes may not be correct.
Statistics do not in any way effect the output of sp_spaceused....
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
August 9, 2011 at 4:58 pm
In other news... Paul Randal is psychic, or can smell a corrupt database from several thousand km away. 🙂
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
August 9, 2011 at 4:46 pm
Vendor-specific hardware diagnostics.
I'd also run SQLIOSim and see if it picks up any funnies.
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
August 9, 2011 at 4:33 pm
p.s. you've either got some IO error, a memory error or you've hit a severe SQL bug. See if you can repo on completely different hardware, see if you can...
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
August 9, 2011 at 4:22 pm
Ninja's_RGR'us (8/9/2011)
ALTER DATABASE [Test Upgrade Dynamics] SET EMERGENCY
DBCC CHECKDB('Test Upgrade Dynamics') WITH NO_INFOMSGS, ALL_ERRORMSGS
And that returns... NOTHING
Ok, then maybe...
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
August 9, 2011 at 4:19 pm
Ninja's_RGR'us (8/9/2011)
Also while I have backups of prod DB, that particular db has never been backed up. It's in full recovery
Which means it's in pseudo-simple recovery (log getting truncated...
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
August 9, 2011 at 4:16 pm
coder_t2 (8/9/2011)
Jeffrey Williams-493691 (8/9/2011)
GilaMonster (8/9/2011)
Insert in batches or use an insert method that can be minimally logged (and drop any nonclustered indexes before you start)
Don't drop the nonclustered indexes -...
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
August 9, 2011 at 3:59 pm
@SQLFRNDZ (8/9/2011)
Log backup strategy some thing...
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
August 9, 2011 at 3:58 pm
http://www.google.co.za/search?q=%22SQL+Server%22+trigger+pseudo+table
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
August 9, 2011 at 2:25 pm
Viewing 15 posts - 24,271 through 24,285 (of 49,552 total)