Viewing 15 posts - 29,821 through 29,835 (of 49,552 total)
Also asked here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=151816
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 20, 2010 at 2:07 pm
Where you install the SQL executable and where the database files are is totally unrelated. You can (as I have) install SQL into the default location (c:\Program files...) and, during...
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 20, 2010 at 2:03 pm
SkyBox (10/20/2010)
Thank you Eights...
You mean Wayne?
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 20, 2010 at 1:00 pm
Did you open books online and look up the syntax for ALTER DATABASE?
ALTER DATABASE database_name
SET { ONLINE | OFFLINE | EMERGENCY }
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 20, 2010 at 11:11 am
Oliiii (10/20/2010)
Sure you can use the GUI all you want, but in an interview you should show you know exactly what to do and not rely on a wizzard.
If you...
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 20, 2010 at 11:07 am
wazlow (10/20/2010)
sorry for that new to all
No need to apologise for anything. I do however need to see the things I asked for to be able to help you further.
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 20, 2010 at 11:04 am
MysteryJimbo (10/20/2010)
I believe its a combination of myth and/or poorly configured traces that have spread this across a multitude of articles.
I have personally brought down a busy production server with...
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 20, 2010 at 11:02 am
SkyBox (10/20/2010)
Has anyone had any first hand experience with losing any data on a SAN system?
Yes.
It's not data loss that Wayne's suggesting mirroring for. It's downtime. Sure, you could restore...
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 20, 2010 at 10:57 am
Errr... it's far from that simple... Never really has been.
Pages are 8k, that's unchanged. Writes, well, maybe take a read through this:
http://technet.microsoft.com/en-gb/library/cc966500.aspx, especially the section on scatter-gather IO.
This is also...
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 20, 2010 at 8:17 am
peterzeke (10/20/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
October 20, 2010 at 7:28 am
peterzeke (10/20/2010)
GilaMonster - are you saying that joining to tabular udfs on large row counts can drastically reduce query performace? If so, what is the recommended approach?
Multi-statement ones can be,...
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 20, 2010 at 7:26 am
There is no built in NLB for any version of SQL. That's 2000, 2005, 2008, 2008 R2
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 20, 2010 at 7:22 am
It is not.
SQL is clustered for availability, it has no scale-out capabilities built in. You can build a scale-out solution yourself, typically with peer-to-peer replication, but it's not trivial.
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 20, 2010 at 7:10 am
Will try and remember to check this evening.
Testing attachments... looks like they're working now. Maybe intermittent glitch.
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 20, 2010 at 6:59 am
What do you mean by 'call a cursor'? A cursor isn't an object that you call, it's an object that you declare, use and then deallocate.
Why do you want 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
October 20, 2010 at 5:38 am
Viewing 15 posts - 29,821 through 29,835 (of 49,552 total)