declare @tab table (col1 char(2))

insert into @tab values

('A1'),

('A2'),

('A3'),

('B1'),

('B2'),

('B3')

SELECT

A.Col1,

B.Col1

FROM

(

SELECT

ROW_NUMBER() OVER(PARTITION BY LEFT(Col1,1) ORDER BY Col1) AS RowNum,

Col1

FROM

@tab

WHERE

LEFT(Col1,1) = 'A'

) AS A

FULL OUTER JOIN

(

SELECT

ROW_NUMBER() OVER(PARTITION BY LEFT(Col1,1) ORDER BY Col1)...

They will be stored in the master and msdb database

Logins stored in master, jobs maintenance plans stored in msdb.

Yes, as disable drops the B-Tree of the index, but leaves the meta data in place, so the only way to get the index enabled again is rebuild, to rebuild...

It is the same you are correct, but with disable / rebuild, you dont need to know the definition of the index to recreate it.

Export them to a flat file - Import Export data wizard

Export them to a different database - SELECT * INTO DB1.dbo.tablename FROM DB2.dbo.tablename

Export them to backup tables in the...

I seriously recommend a lot of reading on the main topics of SQL.

Start with the stairways section of the site and read up on all the topics covered.

Gail also has...

well as 87% is spent on a key lookup, I would add the output column from the key lookup as an included column of the IX_art_ID_client_ID_price..... index on the price...

High CPU chapter in the Accidental DBA guide, would be a good place to start.

Partitioning is for data management not for performance.

If you have the execution plans, upload them as attachments in a SQLPLAN file format and I am sure someone will get around...

The free ones are usually brain dumps and as per the NDA use of brain dumps is considered cheating, if you get caught you will have all existing certification removed...

stop the sql service cleanly, start it up the engine in single user mode, then try shrinking.

I would first take a copy of the database, restore it to somewhere which has lots of space.

Then shrink it, and rebuild all your indexes, as shrinking the data file...

What edition is already installed on the PC now?

If it is going to be the same edition, version and service pack level, just backup master and msdb and any other...

Are you facing issues with free space on the actual disk?