Viewing 15 posts - 30,901 through 30,915 (of 49,552 total)
SELECT Schema_Name(Schema_id) as SchemaName, t.name as TableName, c.name as ColumnName, c.collation_name
FROM sys.tables t INNER JOIN sys.columns c on t.object_id = c.object_id
WHERE collation_name is not null
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
September 7, 2010 at 9:57 am
Before you use Nolock, check that the users are happy with possibly getting incorrect data....
See - http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
Severe blocking is generally the result of poor indexing (not fragmented indexes, just 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
September 7, 2010 at 9:28 am
My preference is two maint plans (when I use maint plans)
1) - Rebuild indexes, update statistics
2) - Integrity check, backup database
Integrity check before backup. There is no point whatsoever in...
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
September 7, 2010 at 9:22 am
If you can afford to duplicate the entire 15 GB table (which is what an index with all columns included will do), and don't care about the impact of that...
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
September 7, 2010 at 8:31 am
ashish.kuriyal (9/7/2010)
you can add one more step to verify the backup when its being copleted, and it will confirm you either backup is valid set or not.
Do note that verify...
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
September 7, 2010 at 7:05 am
I wrote the exams while they were still in Beta. Used Books Online to study.
Or see here for still measured and available resources.
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.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
September 7, 2010 at 7:04 am
You can't. The necessary exams were retired years ago. you can write certs for SQL 2005 and 2008, but not for 2000 any longer.
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.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
September 7, 2010 at 7:01 am
SwayneBell (9/7/2010)
I.e does SQL Server retain a "high water mark" of space...
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
September 7, 2010 at 6:52 am
THE-FHA (9/7/2010)
Clearly the person who asked knows what he wants.
Not necessarily. I've seen many cases where people have asked for things without understanding what they want or what 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
September 7, 2010 at 2:20 am
Just note that it is not a requirement that a CTE start with a ;. It's a requirement that the statement before be terminated with a ;. Since this termination...
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
September 7, 2010 at 1:49 am
For deadlocks, turn traceflag 1222 on and the deadlock graph will be written to the error log.
What exactly do you mean by 'our replication cannot synchronize problem'
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
September 7, 2010 at 1:47 am
Not a suggestion, but...
http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
September 7, 2010 at 12:59 am
What's the output of sp_spaceused?
What's the shrink operation waiting for? (check sys.dm_exec_requests)
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
September 7, 2010 at 12:56 am
Exec sp_lock (which is deprecated, included only for backward compatibility with SQL 2000 and should not be used for new development) will tell you the current locks in the system.
There...
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
September 7, 2010 at 12:55 am
Depends completely on the company. There's no industry-standard definition of titles. The boss can make your titles whatever he (or you) likes, the important thing is what your job responsibilities...
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
September 7, 2010 at 12:51 am
Viewing 15 posts - 30,901 through 30,915 (of 49,552 total)