Viewing 15 posts - 16,636 through 16,650 (of 49,552 total)
Anyone feel up to helping here?: http://www.sqlservercentral.com/Forums/Topic1358758-391-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
September 13, 2012 at 2:11 pm
Otherwise, if the database has transparent database encryption enabled, its backups will be encrypted.
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 13, 2012 at 2:00 pm
No, it's not complaining that the tables are not empty. It's complaining that the file is not empty. There's still an index or a table in that filegroup, you have...
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 13, 2012 at 1:58 pm
Don't see any screenshots.
You have to drop all tables and indexes that are on the filegroup you want to remove. Not empty the tables, drop them.
Once there are no objects...
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 13, 2012 at 1:32 pm
No, no, no, no!!!!!! Do not ever delete ldf files. Will likely leave your DB damaged and unusable.
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 13, 2012 at 1:30 pm
ldf files never belong to a filegroup. They're the transaction log. Only data files can be part of a filegroup.
If you check what files comprise a filegroup, you'd see...
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 13, 2012 at 12:21 pm
nagkarjun1 (9/13/2012)
Enable Lock Pages in Memory Rights
That's debatable whether you want it or not
Page file Size should be 1.5 to 2 times the actual RAM
Err, why? How often do 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
September 13, 2012 at 12:19 pm
.ldf files are not part of filegroups. That's the transaction log.
To drop a filegroup, you drop all tables and indexes in that filegroup, then drop the ndf files in 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 13, 2012 at 11:55 am
Not very often.
It's briefly discussed in chapter 6 of http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
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 13, 2012 at 11:49 am
http://sqlinthewild.co.za/index.php/2011/01/18/distincting-an-in-subquery/
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 13, 2012 at 11:26 am
No need to drop the index. ALTER INDEX and set ALLOW_PAGE_LOCKS to ON. Exact syntax is in Books Online.
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 13, 2012 at 9:34 am
scogeb (9/13/2012)
Jeff Moden (9/12/2012)
Also, what's with all the LTRIM/RTRIM stuff? Data should be properly stored without leading spaces and trailing spaces...
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 13, 2012 at 9:31 am
SQLSACT (9/13/2012)
Once the desired pages are brought into memory, can't the results then be presented? Is there still work to be done?
Do you want a query that's intended to fetch...
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 13, 2012 at 9:29 am
Unless you had a trace in place starting 30 days ago, you cannot get this information. The DMV you used just shows queries that are still in cache, not 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
September 13, 2012 at 4:25 am
It takes time and it causes a recompile of the rest of the procedure and any other plans that use the statistics.
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 13, 2012 at 3:40 am
Viewing 15 posts - 16,636 through 16,650 (of 49,552 total)