Viewing 15 posts - 44,161 through 44,175 (of 49,571 total)
homebrew01 (9/29/2008)
Replication shouldn't make any difference. When was your last FULL backup ?
Replication makes a big difference to logs. On a replicated DB, the log record can't be discarded until...
September 29, 2008 at 2:22 pm
Looks like there's a damaged page in the backup. Can you get another copy of the backup?
If not, try a restore with continue after error in 2005 or 2008....
September 29, 2008 at 2:20 pm
Fraggle (9/29/2008)
Did you try using the CAST function?
It may convert, but the conversion will be completely meaningless. timestamp is not in anyway related to a time.
September 29, 2008 at 2:17 pm
ALZDBA (9/29/2008)
September 29, 2008 at 2:16 pm
Thanks. I'll pass that on.
There are 500 odd tables. None of the tables have hundreds of columns. Interesting, if the DBA added (to the query in sqlplus) the equivalent of...
September 29, 2008 at 2:09 pm
ananda.murugesan (9/29/2008)
hi sqldba,pls tell me, what is the different between incremental backup and differential backup in sql server 200?
SQL doesn't have an incremental backup. It has a full backup, a...
September 29, 2008 at 2:08 pm
No. The restore will restore the DB with the same number of files and filegroups as it had when it was backed up.
September 29, 2008 at 1:51 pm
The storage engine just does data retrieval. It's job it to get pages from disk into memory and, when necessary, back. The query processing engine operates only on pages in...
September 29, 2008 at 1:51 pm
timestamp, despite it's name, has nothing to do with time. It's a binary value unique within the DB that changes whenever the row is changed. It's more a row version...
September 29, 2008 at 1:49 pm
Allen Krehbiel (9/29/2008)
September 29, 2008 at 1:44 pm
Probably because the data type used for the indexId is a tinyint, hence only goes up to 255. 0 is the heap, 1 is the cluster, 255 is the blob....
September 29, 2008 at 1:42 pm
Sandy (9/29/2008)
if you are using the table for highly transactional then you can go for Table variable rather than Temp Table inside store procedure because it will be faster.
Why will...
September 29, 2008 at 1:37 pm
saby (9/28/2008)
Transaction information for database 'tbloy'.
Replicated Transaction Information:
Oldest distributed LSN : (0:0:0)
...
September 29, 2008 at 1:35 pm
davidsalazar01 (9/28/2008)
September 29, 2008 at 1:28 pm
iwantroot (9/29/2008)
GilaMonster
select top 20 *, cast(wait_time_ms as float)/waiting_tasks_count as Avg_WaitTimefrom sys.dm_os_wait_stats
where waiting_tasks_count>0 and wait_type not like 'Sleep%'
order by wait_time_ms desc
This is my output:
Was that while the server...
September 29, 2008 at 1:25 pm
Viewing 15 posts - 44,161 through 44,175 (of 49,571 total)