Viewing 15 posts - 34,906 through 34,920 (of 49,552 total)
P Jones (1/7/2010)
What do other women think - do you want to work with operating systems and networks and hardware or with programming and web applications and databases??
I build and...
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 7, 2010 at 6:51 am
I strongly suggest you don't go the locking route. If you could lock the entire database, you'd essentially be preventing anyone from doing anything until the first process is complete....
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 7, 2010 at 6:47 am
scott.lucas-1068252 (1/7/2010)
Msg 3701, Level 11, State 5, Line 135Cannot drop the table 'dbo.aspnet_Applications', because it does not exist or you do not have permission.
Is that one of the tables 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 7, 2010 at 6:47 am
I don't see an execution plan anywhere.
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 7, 2010 at 6:44 am
scott.lucas-1068252 (1/7/2010)
Gail, If I run the statement I get a list of all the tables I want to drop 😀
Cool. Think your SQL skills are up to using the script...
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 7, 2010 at 3:04 am
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
January 7, 2010 at 2:54 am
So you want to drop all tables in the Owner2 schema?
Does this list all the tables that you want to drop?
SELECT s.name, t.name
FROM sys.tables t INNER JOIN sys.schemas s...
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 7, 2010 at 2:31 am
May I suggest that you start by looking in Books Online for info on the various commands that you want to run.
There's no need to do SP_RECOMPILE and SP_REFRESHVIEW 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 7, 2010 at 2:29 am
I think that depends on whether or not the query requested the varbinary(max) column or 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
January 7, 2010 at 1:43 am
Locking hints would have to be applied in Process1, since it's the one doing the updating.
May I suggest a check at the beginning of Process2, something to check whether Process1...
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 7, 2010 at 1:40 am
We generally don't give interview questions here. It doesn't help anyone to give someone questions and answers so that they can pass an interview they should not have been able...
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 7, 2010 at 1:33 am
*edit removed*
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 7, 2010 at 1:31 am
The SQL Server service account does not have sufficient rights to access that folder. Note, it's the account that SQL runs under that's inportant. Not whatever you're logged in as.
Check...
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 7, 2010 at 1:28 am
Use nvarchar(max) rather than nvarchar(4000)
NText is a deprecated data type, should not be used in new development and will be removed in a future version of 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 7, 2010 at 1:26 am
ALTER DATABASE with the MOVE clause
Take the database offline
Move the files
Bring the database 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
January 7, 2010 at 1:24 am
Viewing 15 posts - 34,906 through 34,920 (of 49,552 total)