Viewing 15 posts - 41,521 through 41,535 (of 49,552 total)
It's used on Vista (and I think Server 2008) to add in an administrative user as, by default, the builtin\admins are no longer automatically sysadmin on those OSs. It's only...
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 22, 2009 at 12:25 am
lucassouzace (1/21/2009)
ok, is Latin1_General_CS_AS
Right. That's case sensitive (that's what the CS shows)
For some strange reason, the hierarchyid data type is case sensitive in some places in a case sensitive database....
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 22, 2009 at 12:10 am
Rajesh kasturi (1/21/2009)
If you run the backup log with truncate_only, I am sure your log file will be...
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 22, 2009 at 12:08 am
Unless you have a good reason not to, every table should have a clustered index.
Tests have shown that with a well-chosen clustering key, all operations are faster on the table...
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 21, 2009 at 1:18 pm
Grant Fritchey (1/21/2009)
I'm inclined to say the second without any data. But I've seen instances where the first can be faster.
If the indexes are good, the stats accurate and 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
January 21, 2009 at 1:15 pm
You can use the windows scheduler and sqlcmd to do scheduled backups. It's not as easy as SQLAgent, but it does work. For sqlcmd, you'll want to use the -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
January 21, 2009 at 1:14 pm
JKSQL (1/21/2009)
which process is faster and better for longevity?
Depends. Test them both under load and see which one scales better. Sometimes the temp table is better 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
January 21, 2009 at 1:05 pm
My guess is that it found a possible index inconsistency in that table. (row in cluster that's not in the noncluster or vis versa)
The way the checkDB algorithm works is...
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 21, 2009 at 12:51 pm
pixye.sb (1/21/2009)
you mean that a user having the role db_datawriter on msdb has by default the same privilege on all databases in that instance?
No. A user with the db_datawriter on...
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 21, 2009 at 7:27 am
thulani.moyana (1/21/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
January 21, 2009 at 7:25 am
It's in the database properties. From object explorer, right click the database and select properties.
It's also probably available with one of the DATABASEPROPERTYEX options
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 21, 2009 at 7:24 am
Why would it need permissions in tempDB? Temp table usage doesn't require any permissions in tempDB, so unless there're doing something like creating permanent tables in tempDB (which the permissions...
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 21, 2009 at 6:57 am
And just note there is a 16 column/900 byte limit on index key size.
Edit: 16, not 60.
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 21, 2009 at 6:52 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
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 21, 2009 at 6:50 am
Disclaimer: Do not do this on a production server. Do not do this to any database that you care about. If you want to play, do so on a 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
January 21, 2009 at 6:33 am
Viewing 15 posts - 41,521 through 41,535 (of 49,552 total)