What I like the best about Hyper-V 3.0 as well as VMWare 5.0 and 5.1 is the fact that Guest OS NUMA-awareness is finally available.

Before these versions, having a virtualized...

The answer as always is : it depends.

Both do something completely different. One updates statistics and...

Lowell (5/22/2012)

---

it looks to me like the cursor is calling a stored procedure [STAT_LK.dbo.stat_v3] for each row;

to change this to a set base, wer would need to see the defintiino...

DBA_SQL (5/21/2012)

---

Error:

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.".

Msg 7321, Level 16, State 2, Line 5

An error occurred...

What error messages...

That's kinda...

NOTE: Important - This example is for an exclusively x64 environment without any Office x86 parts and with this

http://www.microsoft.com/download/en/details.aspx?id=13255

installed

********************

INSERT INTO ... Your_Table

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',

'Excel 12.0;Database=C:\excel-sql-server.xlsx',...

Yes, there is. Here's the PowerShell and AMO (Analysis Management Objects) way. 😉

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") | Out-Null;

[Microsoft.AnalysisServices.Server] $srv = New-Object Microsoft.AnalysisServices.Server;

[string]$ServerName = "Server\Instance";

$srv.Connect($ServerName);

$BackupDestination = $srv.ServerProperties.Item("BackupDir").Value;

$BackupDestination;

Well, it depends.

If you have a standard 18-drive SAN, it doesn't matter whether you have one large LUN or several smaller LUNs all using the same spindles.

You really only have...

Eugene Elutin (5/15/2012)

---

kwe477 (5/15/2012)

---

Excerpt from below link:

...

Dynamic queries:

are nothing more than ad-hoc queries built using a dynamic string. Dynamic queries are considered ad-hoc queries by the optimizer because they...

Have you checked this one out already?

http://blogs.msdn.com/b/psssql/archive/2010/06/23/my-kerberos-checklist.aspx

you could try a

SELECT * FROM [sys].[tables]

where schema_id = 'your_schema_id'

Excerpt from below link:

Ad-hoc query:

created and executed manually through a client. e.g., a user opens up SSMS, writes a query and executes it.

Dynamic queries:

are nothing more than ad-hoc queries...

a starting point might also be to drop the indexes on at least

tblStore

tblSummary

For

tblSticker

tblStickerRange

that might be a solution also, but is depended on the size/config of your box.

Also, am I reading...

Also it could be useful to know the HW-Config of your Box, namely

- CPUs

- I/O Channels

- Memory

- possibly NUMA aware

- what version of SQL Server with Service Pack

- x64/x86