Viewing 15 posts - 27,166 through 27,180 (of 49,552 total)
Sachin Nandanwar (3/23/2011)
Following is the extract from your blog which is your definition of truncation of log
SQL server run the CHECKPOINT truncates the inactive portion of...
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 23, 2011 at 5:05 am
mathew.walters (3/23/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
March 23, 2011 at 5:01 am
The costs can be used that way, but bear in mind that they can be wrong and deceiving. I have a demo (that I did as part of the 24...
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 23, 2011 at 4:59 am
Coincidental, I wrote about what you're probably experiencing
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 23, 2011 at 4:20 am
Basically it means that for some operations only the page allocations are logged, not the details of the actual row inserts. When a log backup is run, the modified pages,...
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 23, 2011 at 4:16 am
It won't break anything, but rather install the tools on a desktop and connect to the server. In general workstation tools don't belong on a server.
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 23, 2011 at 4:08 am
Marvin Maralit (3/23/2011)
Our DBA suggested instead of using Temp Table for large data, I should be using a real table. Is it true?
Probably not, especially if there's going to 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
March 23, 2011 at 3:57 am
A take offline should be near-instantaneous, but it does need an exclusive database lock, which means it has to wait until all connections to the DB are closed.
Either manually kill...
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 23, 2011 at 3:00 am
That's probably just an installation of Express. Express can be installed without any management tools. Typically when that's done the app has a way of doing backups.
p.s. Unless tirvoli has...
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 23, 2011 at 2:16 am
$QLdb@ (3/23/2011)
You can view the information of all the users in SYSXLOGINS table in Master database
sysxlogins contains the information on logins, not users.
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 23, 2011 at 2:04 am
$QLdb@ (3/23/2011)
change the recovery model to simpleBy which transaction log will not get save
After this you can delete the records without logging it into transaction log
That is completely incorrect....
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 23, 2011 at 2:04 am
All data modifications are logged, always.
For minimal log impact, you could delete in a loop, delete 10000 or 50000 or whatever rows at a time, run the loop until all...
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 22, 2011 at 11:56 pm
Yup, it's telling you that the diffs are based on a different full backup to the one you have.
Are all the backups taken natively? Do you have anything else backing...
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 22, 2011 at 11:52 pm
For 2005, 2008 query sys.server_principals, sys.server_role_members and sys.server_permissions, you're looking for anyone a member of the sysadmin role or with control server permissions.
Cannot recall for SQL 2000.
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 22, 2011 at 11:49 pm
A query plan is nothing more than a set of instructions for the query execution engine.
You can store one trivially, run the query with 'include actual execution plan', then 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
March 22, 2011 at 11:47 pm
Viewing 15 posts - 27,166 through 27,180 (of 49,552 total)