Viewing 15 posts - 41,821 through 41,835 (of 49,571 total)
lduvall (1/12/2009)
Shouldn't the TLog backup have reduced and reallocated that unused space?
No. The tran log backup will have removed old log records and made the space inside the file...
January 12, 2009 at 8:32 am
Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic634491-106-1.aspx
January 12, 2009 at 2:18 am
arup_kc (1/11/2009)
But, how SQL server identify each row? Like Oracle, it uses ROWNUM and ROWID.
SQL has no such functions. There's no documented way to get at the storage details...
January 12, 2009 at 2:14 am
It looks like it may have to do with deadlocks. What traceflags do you have enabled? What version of SQL?
Please post in the appropriate forum next time, not just anywhere....
January 12, 2009 at 2:12 am
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...
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
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...
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...
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...
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...
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...
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?
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...
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...
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...
January 11, 2009 at 2:00 am
Viewing 15 posts - 41,821 through 41,835 (of 49,571 total)