Viewing 15 posts - 41,806 through 41,820 (of 49,562 total)
SQL has no concept of timeouts (other that lock timeouts). A timeout is a client application setting that controls how long the client app is willing to wait the server...
January 12, 2009 at 8:54 am
Data volumes
Memory
Disk speeds and usage
CPU speed
database activity
other server activity
Different indexes or statistics
January 12, 2009 at 8:45 am
I don't think you'll be able to do it in one step. SQL 2008 won't allow a database that's in compatibility mode 7, which is what a SQL 7 database...
January 12, 2009 at 8:44 am
winston Smith (1/12/2009)
what pushes the optimizer toward one index over the other if both are providing equal results?
Probably it thinks that the index that has the include columns will have...
January 12, 2009 at 8:39 am
Unlikely. It's not the 32 bit/64 bit. It's that you're trying to mirror between two different versions of SQL.
You can try and set it up, but I doubt it...
January 12, 2009 at 8:34 am
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
Viewing 15 posts - 41,806 through 41,820 (of 49,562 total)