Viewing 15 posts - 36,061 through 36,075 (of 49,552 total)
Though table value functions (well, multistatement ones) do have some performance issues.
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 30, 2009 at 2:21 am
Enterprise edition is not supported on non-server OS's.
Why Enterprise? Those licences aren't cheap and it can't be because of required enterprise-only features if you're upgrading from Express. Consider Standard edition...
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 30, 2009 at 1:52 am
Would someone be willing to keep an eye on this thread?
http://www.sqlservercentral.com/Forums/Topic811359-266-1.aspx
I'm not sure at this point how big a problem it is, but I'm leaving for the airport in 3...
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 30, 2009 at 1:51 am
Ankit Mathur-481681 (10/30/2009)
If it can work 1 level deep why not 2 level. Not even by any workaround????
Because 1 level is not nested and two is?
Do the procs always get...
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 30, 2009 at 1:41 am
Please run the following and post the full output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Take a look at this article. http://www.sqlservercentral.com/articles/65804/
Do you have a clean backup of this database? (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 30, 2009 at 1:37 am
Bob Hovious 24601 (10/29/2009)
.... not to mention practicing martial arts and conquering the galaxy.
Galaxy unfortunately remains unconquered. Haven't touched that game since I mentioned it here. As for martial arts,...
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 29, 2009 at 3:08 pm
CirquedeSQLeil (10/29/2009)
How do you find the time? School, articles, SSC, writing books, work...
School?
It's 11pm and I'm just starting on a report that'll likely take 2-3 hours. Answer your question?;-)
Not...
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 29, 2009 at 3:05 pm
Woot.
Articles finished, slides finished, demos finished. Packing half done (laptop, books, cables and important documents still to do). Just 2 reports to finish and I think one of those 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
October 29, 2009 at 2:57 pm
rudy komacsar - a.k.a. Doctor "X" (10/29/2009)
By upgrading to SP4 you'll be 'supportable by MS until sometime in 2013 !
'supportable' meaning if you have a premier support agreement with MS...
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 29, 2009 at 12:46 pm
Column names and data types you chance with an ALTER TABLE statement. When you say comments, do you mean extended properties?
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 29, 2009 at 11:06 am
CirquedeSQLeil (10/29/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 29, 2009 at 10:09 am
The column names, column data types, that kind of 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
October 29, 2009 at 9:26 am
What are you 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
October 29, 2009 at 9:12 am
By definition, tables have no order. If you don't specify an ORDER BY, the order that the rows will be returned in is not defined and can change.
Change your SSIS...
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 29, 2009 at 9:12 am
If you're talking about directly updating the actual system tables then no, absolutely not.
The stored procs and related commands that do that are there for a reason. On SQL 2000...
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 29, 2009 at 9:03 am
Viewing 15 posts - 36,061 through 36,075 (of 49,552 total)