You could try with Poor Man's SQL Formatter SSMS Add-in.

It doesn't enforce UPPERCASE keywords, but can convert and format the code consistently.

So, you need a command line tool to query the database.

Here are some options:

http://blog.nguyenvq.com/2010/04/15/accessing-ms-sql-server-from-command-line-in-mac-os-x-and-linuxunix/

http://stackoverflow.com/questions/149395/what-are-some-ways-of-accessing-microsoft-sql-server-from-linux

Hope this helps

Gianluca

Duplicate post (sort of).

Replies here please: http://www.sqlservercentral.com/Forums/FindPost1277928.aspx

I would avoid this approach for many reasons.

If you're looking for a results caching solution, take a look at SafePeak.

My suggestion is to speed up the query with appropriate tuning...

John Mitchell-245523 (4/4/2012)

---

600,000 rows in a report? I feel sorry for the person on whose desk that lands! I think some better options include optimising the query for...

I would call a procedure from the report and let the procedure store the results into a staging table with some sort of id which identifies the call.

Then, I would...

You can cast both to DATE type:

SELECT CASE

WHEN CAST(@datetimefield AS DATE) = CAST(@dateonlyparameter AS DATE)

...

So, I guess I should not consider a script...

You could use BCP with xp_cmdshell for instance, but, let me ask you WHY you want to cache results like that.

Do you need a result cache to query later? Why...

I would avoid DBCC commands for this task. Take a look at sys.dm_db_index_physical_stats instead.

If you insist doing this with DBCC, at least create a procedure to wrap the code before...

I suspect that the duplicate call could be due to metadata discovery.

Try changing the "Lazy Schema Validation" property to "True" on the linked server properties page.

This is the downlaod page for MSSQL ODBC driver for Linux.

This page should help you.

_nzrdb6 (4/3/2012)

---

Hi guys,

I'm an average Joe DBA looking after 50 instances across London, Paris and New York. In London and NY SSIS is used for ETL but in Paris the...

GSquared (3/27/2012)

---

L' Eomot Inversé (3/27/2012)

---

Stefan Krzywicki (3/27/2012)

---

GSquared (3/27/2012)

---

[It's a lot of posts, but I've never understood any fascination with "milestone" posts. Number in Hex, Oct, or Bin, and you...