Viewing 15 posts - 28,066 through 28,080 (of 49,552 total)
Koen (da-zero) (1/29/2011)
Yet this is posted in the SQL 11 forum 😀
SQL 11 yes. Not SQL 2011.
It's called SQL 11 (and has been called that since long before the code...
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
January 29, 2011 at 6:25 am
Google doesn't use SQL Server. They have a custom distributed database system.
The one big internet site that uses SQL Server is MySpace. They have a couple hundred SQL Server instances,...
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
January 29, 2011 at 6:22 am
yes, yes and yes. I wasn't listing all the differences (that would be an essay), just some.
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
January 29, 2011 at 6:07 am
No need for additional indexes here, the where clause is on the clustered index key. You would consider creating indexes when your queries filter or join on other columns
This may...
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
January 29, 2011 at 5:30 am
ALZDBA (1/29/2011)
What would be the consequence for applications connected to a could database ??No business ??
Yes, but Cloud's not used all that much here. Bandwidth (especially international) is expensive and...
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
January 29, 2011 at 5:24 am
Sachin Nandanwar (1/29/2011)
Do you think table variables might also face "Allocation Page Contention" the way temp tables do ?
Yes. They're tables in TempDB, they're allocated pages just like any other...
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
January 29, 2011 at 5:23 am
jerry-621596 (1/28/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
January 29, 2011 at 12:12 am
mtillman-921105 (1/28/2011)
Here is a short blog post showing the differences:http://www.sqlservercurry.com/2010/03/temporary-tables-vs-table-variables.html
Unfortunately that article is completely wrong on many points.
Both temp tables and table variables are created in tempDB and assigned...
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
January 29, 2011 at 12:10 am
Steve Jones - SSC Editor (1/28/2011)
Connections to a website do not necessarily mean connections to a database.
Especially if there's connection pooling.
Seriously, the largest number of concurrent connections I've seen...
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
January 28, 2011 at 11:59 pm
mtillman-921105 (1/28/2011)
Well, that's scary. (And I'm kind of surprised at myself when I say that, but the internet is a big deal now.)
Not so much here. It's still 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
January 28, 2011 at 3:12 pm
mtillman-921105 (1/28/2011)
So they reportedly turned off the internet in Egypt.'Makes me wonder how easy it would be to do that here in the US or in England?
Would...
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
January 28, 2011 at 2:47 pm
Tom.Thomson (1/28/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
January 28, 2011 at 2:42 pm
If you mean SQL 2000 to SQL 2008, it's a backup/restore. You do need to test your app thoroughly, as lots changed.
All the system tables are changed during 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
January 28, 2011 at 2:39 pm
You really only have 3 options
Dynamic SQL (not in a function though)
The recompile hint on 2008
Write your code in such a way that you're not using the same piece 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
January 28, 2011 at 1:25 pm
Can anyone help this gentleman locate a split function please http://www.sqlservercentral.com/Forums/Topic1054690-1292-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
January 28, 2011 at 9:55 am
Viewing 15 posts - 28,066 through 28,080 (of 49,552 total)