Viewing 15 posts - 28,111 through 28,125 (of 49,552 total)
Open visual studio 8. New project and check the types of projects. BIDs in SQL 2005 is Visual studio 8, not visual studio 10.
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 27, 2011 at 10:28 am
Sure, you can get index intersections. Doesn't mean you always will nor that they are the most optimal approach
p.s. Yes, part 3 needs an edit in that area, but it...
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 27, 2011 at 10:13 am
Maybe the shortcut's been deleted. Is it in the list of installed programs on your machine?
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 27, 2011 at 10:05 am
Elliott Whitlow (1/27/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 27, 2011 at 9:59 am
There is no error in that screen shot.
If you mean the red X, that just means that feature is not currently installed and is not selected for installation.
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 27, 2011 at 9:57 am
If a different action is taken on update than on insert and no code is in common they should be two triggers. Single responsibility
What I'm saying is that if your...
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 27, 2011 at 9:46 am
Linked servers are for databases on other servers.
FROM <database>.<schema>.<tablename>
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 27, 2011 at 9:35 am
What error? There's no error on that screen.
BIDS is set to install, so click next and go through the installation.
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 27, 2011 at 9:33 am
TempDB is on an SSD drive and you still have IO bottlenecks? What are you doing to it?
What lead you to diagnose IO bottlenecks?
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 27, 2011 at 9:19 am
What's the RAID level of the drive that TempDB is currently on? What's it sharing 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
January 27, 2011 at 8:39 am
Maybe. Are you seeing IO bottlenecks on your tempDB? If not, adding files and placing them on multiple drives is not going to help.
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 27, 2011 at 8:23 am
Which edition of SQL? BIDs is not included in the free edition.
If it's a paid edition, install and make sure that both 'Management tools' options are checked
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 27, 2011 at 7:42 am
No such thing as a physical or logical instance of SQL. Could be something unrelated. Why don't you ask the person that you heard it 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
January 27, 2011 at 6:20 am
http://msdn.microsoft.com/library/ms166367.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 27, 2011 at 3:09 am
It'll be in the default trace if it was recent enough, otherwise no way without having had a DDL trigger present at time of creation.
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 27, 2011 at 3:06 am
Viewing 15 posts - 28,111 through 28,125 (of 49,552 total)