Viewing 15 posts - 47,281 through 47,295 (of 49,552 total)
Only 431 has sims. All the others are case studies and multiple choice.
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
February 26, 2008 at 11:40 am
Check the cluster logs and the event logs to see if you can find a reason for the service to fail over.
Agent XPs are always switched to 0 as 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
February 26, 2008 at 11:36 am
Order by in an insert have no meaning, and if you don't specify the order in a select, no order is guaranteed.
Rather do it this way.
insert into #table
select * from...
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
February 26, 2008 at 11:35 am
It they're written badly, they can be.
Personally, I've not found views to be a problem, unless there are layers upon layers of views. If views reference other views which reference...
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
February 26, 2008 at 11:29 am
What's the data type of the column?
If it's datetime, it doesn't have a format. The format of a datetime is solely due to the way it's queried.
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
February 26, 2008 at 11:29 am
I'm guessing Jeff has something like this in mind. It's not a pivot, it's a concatenation and all the values will appear in one column.
DECLARE @ConcatB VARCHAR(8000)
SET @ConcatB = ''
SELECT...
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
February 26, 2008 at 11:21 am
Why.... ????
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
February 26, 2008 at 11:20 am
If you restored a 2000 database onto 2005, you need to update all the statistics. SQL 2005 keeps more detailed stats than SQL 2000 did. The 2005 optimiser can use...
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
February 26, 2008 at 1:28 am
What method are you usind to see what's been excuted?
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
February 25, 2008 at 10:21 pm
Create the login with a matching SID and you should be good to go.
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
February 25, 2008 at 10:10 pm
You mean how to match up the newly created login with the database user?
Fairly easy. The link between a login and the database user is the SID. You can...
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
February 25, 2008 at 12:48 pm
Something small that may help.
I just noticed that the forum combo box at the bottom of every page has all the forums in it. Including all the hundreds of 'Content...
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
February 25, 2008 at 8:10 am
Have you updated stats/rebuilt indexes after migrating the db to 2005?
If you look at the execution plan for both, what are the differences?
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
February 25, 2008 at 8:04 am
You need to update the statistics on all of your tables. SQL 2005 keeps more detailed column statistics than SQL 2000 did. The 2005 optimiser can use the older stats,...
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
February 25, 2008 at 6:46 am
Duplicate post. Ref - http://www.sqlservercentral.com/Forums/Topic459568-359-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
February 25, 2008 at 12:59 am
Viewing 15 posts - 47,281 through 47,295 (of 49,552 total)