kim.talley (2/20/2009)

---

These are not small tables - they have 500,000-1,000,000 rows on them so the fragmentation is a problem. If I manually run the defrag on the tables after the...

k.przewozniak (2/20/2009)

---

Hi,

Can you tell me if there is counter of the query that will let me check how many users are connected for to database? I know counter SQLServer:General Statistics:...

micsak (2/20/2009)

---

Thanks for your reply,

Actually I want to copy the database from one SQL server 2008 to another Sql server 2008. 1st server is active server and second server is...

You don't have to worry about...

tkrajasekar (2/19/2009)

---

Hi,

Thanks for ur valuable information.

Its is possible to recover deleted records or deleted one table without backup(in Oracle having Flashback Query or Flashback Table or Recyclebin option)

What about...

GilaMonster (2/19/2009)

---

elay (2/19/2009)

---

Server: Msg 8933, Level 16, State 1, Line 1

Table error: Object ID 1654296953, index ID 50. The low key value on page (1:548364) (level 0) is not >=...

kim.talley (2/19/2009)

---

The tables are 90% fragmented after the load. My fill factor is set to 80% - these tables are loaded fresh nightly but are updated/inserted/deleted from throughout the day...

kim.talley (2/19/2009)

---

I have several tables in a database (not every table) that are reloaded nightly through an SSIS package. Obviously, this causes my non-clustered indexes to be continually fragmented on...

dale_keller (2/19/2009)

---

Hi,

I was wondering what are the best practices for maintaining stored procedures? Is there source code management for stored procedures in SQL Server 2005? I know...

Yep, always delete the rows in chunks for every 1000 rows or 10,000 rows and then after deletion process is done you can set up a job to Shrink the...

Bruce W Cassidy (2/19/2009)

---

BTW, this is one reason why I'm not fond of industry qualifications. All they really do is show that someone can study to pass an exam...

Thats what is more important. Basics should be strong foe...

But you dont have to do checktable, checkalloc once checkdb is done as checkdb checks integrity on all objects.

I just got an article about bcp, read through it check this out:

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1348311,00.html?track=NL-418&ad=688872&asrc=EM_NLT_5903736

BOL is the best source.