Viewing 15 posts - 32,626 through 32,640 (of 49,552 total)
Also check for any errors reported from the IO subsystem.
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
June 2, 2010 at 11:49 am
iirc there are commercially available shopping cart components for ASP.Net. May be cheaper to buy one of those than reinventing the wheel.
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
June 2, 2010 at 11:49 am
System tables are stored in the primary filegroup and cannot be moved.
You should be able to remove the second file if you first do a shrinkFile with the EmptyFile option
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
June 2, 2010 at 11:46 am
Likely that the log backup is damaged then. It's one backup that consistently fails? If you stop before that backup, bring the DB online and checkDB, is the database still...
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
June 2, 2010 at 5:05 am
Why the hell are you shrinking the database after rebuilding indexes? You may as well not bother rebuilding indexes at all since the shrink will fragment them probably worse than...
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
June 2, 2010 at 2:33 am
passivebyz (6/2/2010)
We have all our applications in SQL Server 2005 SP3 and do not want to upgrade to SQL Server 2008 until this year end. Because we do not use...
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
June 2, 2010 at 2:19 am
you're trying to do a log backup while some file operation (file add, grow, remove) is in progress. As the error says, they cannot run together. Rerun the job when...
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
June 2, 2010 at 2:15 am
Identity
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
June 2, 2010 at 2:01 am
http://support.microsoft.com/lifecycle/?LN=en-us&x=2&y=13&p1=2855
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
June 2, 2010 at 1:50 am
Take a look through this article - http://www.sqlservercentral.com/articles/64582/
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
June 2, 2010 at 1:47 am
malleswarareddy_m (6/2/2010)
select i.name as [Index],i.type_desc as [Index type],T.name as [Table name],C.name as [ColumnName]
from sys.tables T inner join sys.columns C on C.object_id=T.object_id
inner join sys.indexes 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
June 2, 2010 at 1:43 am
Open object explorer, connect to the server
Expand out database->tables->the table you're interested in-> indexes
You can write a query, the views that you need are sys.indexes and sys.index_columns. It'll take some...
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
June 1, 2010 at 11:58 pm
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Why do you think you need a loop?...
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
June 1, 2010 at 11:56 pm
Dependency info is only stored (poorly) for objects in the same database. You'll have to check for job dependencies manually (by checking the definition of the jobs)
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
June 1, 2010 at 11:42 pm
EXEC xp_cmdshell 'bcp "SELECT * FROM [DB_SCG].[SHIVA].[TB_Category] " queryout "C:\bcptest.txt" -T -c -t,'
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
June 1, 2010 at 11:36 pm
Viewing 15 posts - 32,626 through 32,640 (of 49,552 total)