Viewing 15 posts - 33,601 through 33,615 (of 49,552 total)
Joy Smith San (3/9/2010)
how to find os 32bit or 64bit.
Start ==> Run ==> Wwnver
You mean WinVer?
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
March 9, 2010 at 3:49 am
A trigger.
Foreign key constraints cannot reference objects in other databases so to do cross-DB referential integrity you need triggers.
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
March 9, 2010 at 3:41 am
Enterprise edition is not supported on non-server operating systems. So you should be installing Enterprise edition on one of the Windows Server operating systems (Server 2003 or Server 2008)
If this...
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
March 9, 2010 at 3:39 am
Just wait until you have a maintenance window and do the index drop then.
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
March 9, 2010 at 3:35 am
nadersam (3/9/2010)
The user has application has executed its query already but user didn't close his screen so data is still cashed in memory.
Just cached in memory wouldn't affect anything. There...
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
March 9, 2010 at 1:41 am
Select Count(*)
FROM CourtHearing
WHERE
CASE WHEN postponement_date is not null
THEN DATEDIFF(dd, postponement_date, GETDATE())
ELSE DATEDIFF(dd, Hearing_date, GETDATE())
END > 30
It won't perform...
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
March 9, 2010 at 12:46 am
It's possible to automate backups on SQL Express, just not with SQL Agent because it's not included. Some people use Windows Scheduler, some use 3rd party scheduling tools. I'd suggest...
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
March 9, 2010 at 12:42 am
I wonder why you're getting the same log impact from selective rebuilding as from rebuilding all then....
Try changing the schedule from every 2 weeks to every week, and change 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
March 9, 2010 at 12:40 am
Ben Vegiard (3/8/2010)
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
March 8, 2010 at 2:26 pm
The alter statement is fully logged, so the before and after values for each of those rows will be logged so that the alter can be undone or redone if...
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
March 8, 2010 at 1:50 pm
Ack!
Dump transaction is deprecated in SQL 2005 and removed in SQL 2008. Backup with No_Log is also deprecated in 2005 and gone in SQL 2008. Besides, the recovery model is...
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
March 8, 2010 at 1:48 pm
CirquedeSQLeil (3/8/2010)
Jason must not be paying attention. I thought George was asking a serious question. (To segue from Gails post.)
I 'complained' about people repeating my posts word for word,...
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
March 8, 2010 at 1:42 pm
Oh my....
I'll be blunt. I am surprise that ever performs acceptably. The 'catch-all' query form that you have there does not perform well. It is seriously prone to very, very...
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
March 8, 2010 at 1:39 pm
george sibbald (3/8/2010)
ok, now is this a double bluff or is jason not paying attention?
Somehow I suspect the latter. 🙂
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
March 8, 2010 at 1:24 pm
george sibbald (3/8/2010)
does anyone else feel that way?:-D
Not at all, whereever did you get that idea from? 😀 :hehe:
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
March 8, 2010 at 1:22 pm
Viewing 15 posts - 33,601 through 33,615 (of 49,552 total)