Viewing 15 posts - 28,621 through 28,635 (of 49,552 total)
It depends on the kind of workload, on how much usage of temp tables and table variables there is, on how often queries spool, sort and hash, on trigger usage,...
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 5, 2011 at 10:39 am
You can only explicitly move an object to a filegroup. If there are multiple files in a filegroup, the data will be striped across them all, you cannot explicitly control...
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 5, 2011 at 10:35 am
Brandie Tarvin (1/5/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 5, 2011 at 10:31 am
Kwisatz78 (1/5/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 5, 2011 at 9:36 am
The object name in SP:StmtCompleted is the name of the stored procedure that the statement is part of. It will not be a table name. (what do you put 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 5, 2011 at 7:53 am
No, it's no possible. You can tell what tables the data was discarded from, but not what data was lost. To do that, you'll need a clean backup from before...
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 5, 2011 at 7:20 am
Not an error I'm familiar with. Let me consult an expert.
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 5, 2011 at 6:05 am
What are you using to do log backups? Are those native backups or some 3rd party tool?
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 5, 2011 at 6:01 am
Carlton Leach (1/5/2011)
Because you'll be looking to restore it if possible.
Maybe. Depends on a number of factors.
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 5, 2011 at 5:52 am
You have database corruption, at least one page is damaged and not readable.
That's not the full output of checkDB, please run the following and post the full and complete output.
DBCC...
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 5, 2011 at 5:29 am
parm_singla (1/5/2011)
In general checking for nullablilty for parameter would be better than checking for nullablilty for the column.
Errr... Depends completely on what you're trying to do. If you need to...
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 5, 2011 at 4:05 am
For tables you can query sys.partitions. The row count is in there (filter for index_id in 0,1). For views you'll have to run SELECT Count(*), the row counts aren't stored...
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 5, 2011 at 2:26 am
In addition. If you have absolutely no experience in tuning, you're going to struggle in doing it. It's one of those areas where experience really is key. See if you...
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 5, 2011 at 2:00 am
Entire books have been written on performance tuning (several of them)
Start with these:
Inside SQL Server 2005: Query Tuning and Optimisation by Kalen Delaney et al.
SQL Server 2008 Query Performance Tuning...
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 5, 2011 at 1:17 am
TheSQLGuru (1/4/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 5, 2011 at 1:09 am
Viewing 15 posts - 28,621 through 28,635 (of 49,552 total)