Viewing 15 posts - 39,976 through 39,990 (of 49,552 total)
Not using T-SQL. To do that you'd need to use xp_cmdshell and issue OS commands
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
April 4, 2009 at 4:00 am
Most likely someone's been directly updating the system tables after configuring the server to allow updates to them. This is the usual kind of mess that results from someone doing...
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
April 4, 2009 at 3:58 am
Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.
What's the results from...
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
April 4, 2009 at 3:16 am
randhirdadwal (4/3/2009)
.mdf and .ldf gets deleted. Services were stopped and .mdf and .ldf gets deleted.
Any idea who did that? There should be entries in the application event log and they...
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
April 4, 2009 at 2:47 am
You can also create the primary key as a nonclustered index and then create the cluster elsewhere.
ALTER TABLE .. ADD CONSTRAINT ... PRIMARY KEY NONCLUSTERED
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
April 4, 2009 at 2:46 am
Is this still a SQL 2000 server or has it been upgraded to a SQL 2005 server?
It's an important question that needs an answer. The methods of fixing are very...
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
April 4, 2009 at 2:45 am
randhirdadwal (4/3/2009)
I have tried doing that and I was able to take a transactional log backup only using the option with with truncate only.
Backup log with truncate only means truncate...
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
April 4, 2009 at 2:44 am
Interview question?
Triggers fire when a change happens to a table. That's it. If you want scheduling, try SQL Agent.
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
April 4, 2009 at 2:42 am
Torres (4/3/2009)
I assumed this was a common option with most udfs. Or not?
Well, there's two different types of table valued udf, and they follow completely different rules.
The inline table valued...
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
April 4, 2009 at 2:27 am
Paul Randal (4/3/2009)
Gail (and others) - once a database is upgraded and checksums are enabled, torn-page protection is still in place until a page is subsequently changed
I'm just surprised that...
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
April 3, 2009 at 4:25 pm
You're looking for the MCITP certifications. There are two, one for dev, one for admin
http://www.microsoft.com/learning/mcp/certifications.mspx
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
April 3, 2009 at 3:22 pm
rubes (4/3/2009)
Thanks for the input Gail. Checksums are enabled and have been for quite a while.
Odd, because there's references to torn pages. It means that not all the...
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
April 3, 2009 at 3:15 pm
Torres (4/3/2009)
The udf is a Table-valued Function, returning a dataset.
Multistatement or inline?
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
April 3, 2009 at 2:57 pm
Torres (4/3/2009)
Hello.When joining a table with a udf, does the Server process the udf query independently, or does it consider the joins and any where conditions?
Depends. If it's a multi-statement...
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
April 3, 2009 at 1:48 pm
Paul TriVegg (4/3/2009)
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
April 3, 2009 at 1:35 pm
Viewing 15 posts - 39,976 through 39,990 (of 49,552 total)