Lynn Pettis

Forum Replies Created

Viewing 15 posts - 10,666 through 10,680 (of 26,489 total)

RE: how to delete duplicate col.

Danzz (7/18/2012)
Can I get T-sql statement.
Based on what? We don't have anything useful from you to provide you with any code that would be useful to you. If...

July 18, 2012 at 12:08 pm

#1514422
RE: Mirroring to multiple databases possible?

Simple answer, no. You do get this capability in SQL Server 2012 with AlwaysOn.

July 18, 2012 at 11:38 am

#1514392
RE: Import fails using SQL Server Import and Export Wizard

Your import is failing because you are trying to put 'False' or 'True' into a bit field. You need to convert the boolean value to a 0 or 1...

July 18, 2012 at 11:21 am

#1514380
RE: Import fails from flat file to SQL Server in BIDS

Edit: -- Double posted, sorry.

July 18, 2012 at 11:00 am

#1514365
RE: Import fails from flat file to SQL Server in BIDS

Please post any replies here.
Please, do not double post your problem. You already have a thread started for this problem, let's keep all the work there instead of fragmenting...

July 18, 2012 at 10:59 am

#1514364
RE: Time Zones

djackson 22568 (7/18/2012)
Lynn Pettis (7/17/2012)
If I remember correctly there is a part of Indiana that also does not recognize DST. So, depending on Daylight Savings Time or Standard Time,...

July 18, 2012 at 10:56 am

#1514362
RE: TSQL that returns every item in the left table of a "left outer join" for several rows of the right table in the join?!

First, please note how I setup your test data. This is what you should do for us to make it easier to help you. Please, this lets you...

July 18, 2012 at 10:27 am

#1514344
RE: delete rows in loops of 5000 rows

Jeff Moden (7/18/2012)
Lynn Pettis (7/17/2012)
Jeff Moden (7/17/2012)
Lynn Pettis (7/17/2012)
Read this: http://www.sqlservercentral.com/articles/T-SQL/67898/
Since you are using SQL Server 2008, stay away from using [font="Arial Black"]@@rowcount [/font]to control your batches.
I guess I'm missing...

July 18, 2012 at 9:17 am

#1514286
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (7/17/2012)
Lynn Pettis (7/17/2012)
I've yet to see Welsh offer anything significant, though I don't read every thread anymore.
Mostly requests for assistance, but I have tried to...

July 18, 2012 at 9:16 am

#1514285
RE: Cannot defrag indexes

pooyan_pdm (7/18/2012)
You can also try it to see what happens
I have, I am talking from experience. If you have a clustered index that is highly fragmented, rebuilding it will...

July 18, 2012 at 1:16 am

#1514031
RE: Cannot defrag indexes

pooyan_pdm (7/17/2012)
It is the clustered index key that stored in the nonclustered leaf level pages and not the address of any thing unless the tables is a heap which in...

July 17, 2012 at 11:44 pm

#1514004
RE: delete rows in loops of 5000 rows

Jeff Moden (7/17/2012)
Lynn Pettis (7/17/2012)
Read this: http://www.sqlservercentral.com/articles/T-SQL/67898/
Since you are using SQL Server 2008, stay away from using @@rowcount to control your batches.
I guess I'm missing it. Why stay away...

July 17, 2012 at 11:17 pm

#1514002
RE: Cannot defrag indexes

pooyan_pdm (7/17/2012)
As far as I know in the leaf level of any nonclustered index in addition to index key(s) or included columns, the clustered index key(s) are stored. In this...

July 17, 2012 at 11:15 pm

#1514001
RE: Cannot defrag indexes

pooyan_pdm (7/17/2012)
By rebuilding Clustered indexes ,index definition(index key) are not changed so why should any Nonclustered index get rebuilt??
The clustered index maintains the logical order of the data. This...

July 17, 2012 at 7:08 pm

#1513972
RE: Are the posted questions getting worse?

Evil Kraig F (7/17/2012)
Lynn Pettis (7/17/2012)
As long as he has been working with SQL Server, some of these questions are just hard to believe.
What if I had asked the same...

July 17, 2012 at 5:54 pm

#1513951

Viewing 15 posts - 10,666 through 10,680 (of 26,489 total)