Using Powershell you can query SQL Server and create rich excel sheets with the data.

http://www.petri.co.il/export-to-excel-with-powershell.htm

http://blogs.msdn.com/b/buckwoody/archive/2009/11/09/create-an-excel-graph-of-your-big-tables-with-powershell.aspx

nts 4650 (6/7/2013)

---

For set a SQL to return HTML CODE with mailto you can exec this sql:

Dim Sql As String = "Select Coalesce(NombreCliente,'') +'

Teléfono:'+ Coalesce(TelefonoParticular,'') + '

Movil:' + Coalesce(TelefonoMovil,'') +...

I modified sp_send_dbmail and added the following line at the start of the proc.

SET @body = @body + CHAR(13) + CHAR(10) + CHAR(13) + CHAR(10) + 'SQL Server Mail Sent...

1. Create new filegroup.

2. Create new 50Gb file on new filegroup.

3. Rebuild all indexes onto new filegroup.

4. Drop old filegroup (or shrink to tiny if it is PRIMARY).

This way you...

Ross.M (5/23/2013)

---

Sean Pearce (5/23/2013)

Right click your job in SSMS

Script Job as -->

DROP And CREATE To -->

New Query Editor...

KoldCoffee (5/22/2013)

---

I altered a sql script the other day to handle for a column containing NULLs. Basically, in the case of a NULL I wanted the value 'Other' to...

Ross.M (5/23/2013)

---

Sean Pearce (5/23/2013)

---

Ross.M (5/14/2013)

---

So my questions are:

(1) What might have caused this?

(2) Is it safe to just...

Ross.M (5/14/2013)

---

So my questions are:

(1) What might have caused this?

(2) Is it safe to just do an UPDATE...

SQL_ME_RICH (5/22/2013)

---

Hey Mister Magoo!

Well - that definitely changed things, but now it creates a whole new error all together (I went back to the first set of INSERT statements, and...

If the columns are nullable then you can concatenate.

CREATE TABLE House

(House_No_Start VARCHAR(10) NULL,

House_No_End VARCHAR(10) NULL,

House_Name VARCHAR(50) NULL);

GO

INSERT INTO House VALUES

('1', '3', NULL),

('2', NULL, NULL),

(NULL, NULL, 'The Manor');

GO

SELECT

ISNULL(House_No_Start, '') + ISNULL('...

The Exchange administrators change something and the problem was resolved. I'm not sure what they changed as it was at...

Is this on a physical server or a VM?

I just tried to replicate my findings from yesterday and found some differences. Then I realized I was on a different server with different MAXDOP settings. I reran my test...

Scenario A - Clustered Index. This should read one page and write one page.

Scenario B - Clustered Index & non-participating non-clustered Index. This should read one page and write one...

I realize this...