Viewing 15 posts - 40,111 through 40,125 (of 49,552 total)
70-432 is the Technical Specialist, database administration.
70-433 is the Techincal Specialise, database development.
They are separate certifications. Are you a dev or an admin?
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
March 29, 2009 at 1:04 pm
john (3/29/2009)
1. I have local administrator access and I can stop the SQL service off hours. How do I proceed?
First you need to identify whether SQL is installed as...
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
March 29, 2009 at 1:03 pm
darth.pathos (3/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
March 29, 2009 at 12:40 pm
Steve Jones - Editor (3/29/2009)
Gail, any video?
From dev days and tech days maybe. I'll have to check with MS. Nothing really exciting. Several sharepoint, LINQ, Entity framework, silverlight, wpf ...
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
March 29, 2009 at 12:00 pm
homebrew01 (3/29/2009)
I'm trying to figure out if the 4th update completed partially, or if none of the records got updated.
It would have been all or nothing, 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
March 29, 2009 at 11:56 am
john (3/29/2009)
1. Is there a way to reinstate the local Administrator's rights without the SA login?
Yes, but it requires that you are local administrator on the server that's running SQL....
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
March 29, 2009 at 11:50 am
Matt (3/29/2009)
GilaMonster (3/29/2009)
Check the index usage stats DMV for that info,Thanks Gail, excuse my ignorance but how do I do that?:blush:
SELECT * from sys.dm_db_index_usage_stats
Check out Books Online for 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
March 29, 2009 at 8:52 am
darth.pathos (3/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
March 29, 2009 at 8:51 am
darth.pathos (3/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
March 29, 2009 at 7:33 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic685708-338-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
March 29, 2009 at 7:26 am
homebrew01 (3/28/2009)
I assume that some records will be updated and some won't ? There is no begin tran or commit that would do a rollback.
Not at all. Even thought...
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
March 29, 2009 at 7:23 am
That syntax works fine in SQL. If it's not working in the SSRS query interface, maybe create a stored procedure that takes the parameter and call that from SSRS
declare @i...
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
March 29, 2009 at 7:20 am
Matt (3/29/2009)
Is this an acceptable amount or should I try to reduce this number?
Maybe.
Are they all used? Check the index usage stats DMV for that info, but note that 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
March 29, 2009 at 7:12 am
Take a look at this article over at Simple Talk. It goes into creating the trace scripts and running them. http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
If you need an hour on/hour off 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
March 29, 2009 at 7:09 am
James Brown (3/28/2009)
Since the programming has not changed, my thought is that there are hardware problems. Can I get some options as to what the problem may be?
Typically corruption...
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
March 28, 2009 at 2:44 pm
Viewing 15 posts - 40,111 through 40,125 (of 49,552 total)