Viewing 15 posts - 41,806 through 41,820 (of 49,552 total)
Just post it exactly as it was written into the errorlog. You can cut off the log datatime if you like.
Easiest way is to open the errorlog in a text...
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 12, 2009 at 2:11 am
What are you looking to do with the CLR?
In most circumstances, especially when dealing with data access, T-SQL outperforms CLR procs/function
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 11, 2009 at 11:31 pm
Gautam Saha (1/11/2009)
is supposed to move the contents of a file to all the other...
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 11, 2009 at 11:22 pm
BI/DB (1/11/2009)
When you say some are long, what do you mean by that?
Lots of reading. I had one where the question was almost a full screen
How many questions in...
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 11, 2009 at 11:22 pm
Steve Jones - Editor (1/11/2009)
Gail, not sure if this is a language thing, seeing brackets in your post between the various items.
Whoops. That's not right.
I usually use < > to...
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 11, 2009 at 11:31 am
As I mentioned in the other thread, with SQL 2000, there isn't a really easy way to do this. You could insert the results into a temp table or table...
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 11, 2009 at 6:12 am
Do you want to see all the indexes in all of the databases on the server? If index_physical_stats is run for one database, it's easy to get index names. If...
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 11, 2009 at 6:09 am
Dugi (1/11/2009)
I don't know what is your experience with MS Access...but if you want to learn SQL you should leave Access at all!
What's wrong with MS Access?
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 11, 2009 at 6:03 am
@jit fr Cochin (1/11/2009)
Am using SQL 2000..
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...
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 11, 2009 at 2:32 am
I wrote it as a beta exam. Fairly standard, multiple choice, pass mark 700. If you've written previous MS exams, the format won't surprise you. I found several of 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
January 11, 2009 at 2:04 am
Many of the DBCC statements have an undocumented option TABLERESULTS which changes the output of the statement from text to a resultset that can be inserted somewhere.
With OPENTRAN, it'll 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
January 11, 2009 at 2:00 am
Lynn Pettis (1/10/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
January 11, 2009 at 1:56 am
Look up alter database in Books Online. There's commands to add a file and also to add a filegroup. Or you can do it from the files tab of 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
January 11, 2009 at 1:50 am
Stephanie J Brown (1/10/2009)
Hakima? Which martial art?
Aikido
Mine's aikido, and in terms of dress code, our dojo has two uniforms - the white ghi, and the white ghi...
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 11, 2009 at 1:36 am
Lynn Pettis (1/10/2009)
You know, I don't know? Maybe.
Now that will look impressive in your sig...
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 10, 2009 at 1:20 pm
Viewing 15 posts - 41,806 through 41,820 (of 49,552 total)