Viewing 15 posts - 48,631 through 48,645 (of 49,552 total)
For instance I dont want to have to prepend all the tables in my query with the fully qualified name.
Why not? Unqualified naming can lead to slower queries and unnecessary...
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
May 31, 2007 at 12:21 am
SQL unfortunatly likes to be on a server of its own. It doesn't like sharing resources with anything. It could be worse. I've seen someone put SQL on the same...
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
May 30, 2007 at 7:00 am
Having SQL Server on the same machine as exchange server is not a recomended practice.
See if you can find out how much memory SQL is using and how much exchange...
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
May 30, 2007 at 6:33 am
I would suggest running it with the execution plan on, as well as the IO and time statistics. That way you can work out which of the queries are 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
May 30, 2007 at 5:41 am
Sounds like a good candidate for transactional replication.
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
May 30, 2007 at 4:50 am
Then partition them. Use whatever parition scheme makes the most sense for the tables
They don't all have to have the same partition function. Related tables don't have to be correlated.
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
May 30, 2007 at 1:08 am
Rob, sounds like you need some on-site help. Whereabouts are you based?
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
May 30, 2007 at 12:22 am
So why don't you come back?
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
May 30, 2007 at 12:20 am
The MSDE box was a test box not the production box. If tou read the first post, he is using SQL 2000 sp4 as the production db
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
May 30, 2007 at 12:19 am
Ah, sorry. I misunderstood. I thought you wanted to convert three tables into 1 partitioned table.
As I said before, the examples may show partitions done on datatime columns, but 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
May 30, 2007 at 12:15 am
I think you've misunderstood partitioned tables.
Partitioned tables are for when you want to split a single table into pieces either for IO performance or for fast loading and deleting 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
May 28, 2007 at 8:01 am
Partitioned tables don't need any specific scolumn types in them. The common example is to partition on a datetime column (ann rows between 1 jan 2005 to 31 dec 2005...
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
May 28, 2007 at 5:06 am
I have a client with SQL 2000 SP4 on his Small Business Server 2003.
From what I read, the real server is full SQL. MSDE was used as a test by...
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
May 28, 2007 at 12:05 am
Can I run the DBCC DBREINDEX commands on a database that's in use? I found an article on the web that says go ahead, and another that warns NEVER to...
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
May 28, 2007 at 12:03 am
There is no object 0. If a page is allocated to object 0, it means that it is an unowned (empty) page. It sounds like there may be some chain...
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
May 25, 2007 at 7:20 am
Viewing 15 posts - 48,631 through 48,645 (of 49,552 total)