rhythmk (7/12/2012)

---

karen.blake (7/12/2012)

---

Hi there,

I am hoping that you can help me with a problem I am having using CASE in a query via a linked server.

I have set up a...

MickyD (7/10/2012)

---

Hi everyone.

After some advice , on a SQL 2000 server.

DBCC SHOWCONTIG scanning 'xxxx' table...

Table: 'xxxx' (562101043); index ID: 0, database ID: 17

TABLE level scan performed.

- Pages Scanned................................: 7175

- Extents...

baabhu (7/10/2012)

---

Recommendation by Microsoft.

1) Fragmentation less than 30%. Reorg.

2) Fragmentation greater than 30% Rebuild.

3) If the table has got less than 8 pages don't take any action....

Smaller backup size... less storage...

OK, just keep in mind that the above script returns the data file size only so if you need the database file itself (data+log) you would need to write something...

Danzz (7/9/2012)

---

Thanks surma,

But I cant get the Database size info, form the statement [select * from sys.databases]

I need database name, DB size & recovery model in single...

Hi,

Do a google search on lock pages in memory and sql max server memory.

Lynn Pettis (6/29/2012)

---

The clustered index will still not guarantee the order of the data when output via a select statement.

The only way to guarantee the order of the data is...

Welsh Corgi (6/28/2012)

---

Thanks foe the sugesstions.

When I execute the dynamic sql I get the following error:

(169 row(s) affected)

Msg 1038, Level 15, State 4, Line 1

An object or column name is...

I like Mike's CSV solution a lot better but in case you need to go the dynamic way this should be a starting point;

IF OBJECT_ID('tempdb..#tmp') IS NOT NULL

...

Hi,

Try this or use a dynamic pivot solution that is more flexible

;

WITH c AS ( SELECT [ROMA - Acceptance Fee] AS ROMA_Accept_Fee ,

...

SqlSpider... (6/28/2012)

---

clayman (6/28/2012)

---

SqlSpider... (6/28/2012)

---

Hi All,

I am doing login downgrade in My Server...

this is my Script It is Throwing Error. Please Let me know if you have...

SqlSpider... (6/28/2012)

---

Hi All,

I am doing login downgrade in My Server...

this is my Script It is Throwing Error. Please Let me know if you have any ideas..

...

Doesn't make much sense what you're trying to do here.

If you want to display your data in a specific order just use order by in yor select. As simple as...

What do you mean by not working?

Where did you declare your variables?