Viewing 15 posts - 5,251 through 5,265 (of 8,761 total)
Lynn Pettis (5/18/2015)
Eirikur Eiriksson (5/18/2015)
Lynn Pettis (5/18/2015)
At some point, you have to work with the people in the best position to help.Must admire your patience Lynn!
😎
What, me patient? Good...
May 18, 2015 at 2:12 pm
Lynn Pettis (5/18/2015)
At some point, you have to work with the people in the best position to help.
Must admire your patience Lynn!
😎
May 18, 2015 at 2:02 pm
Ed Wagner (5/18/2015)
Eirikur Eiriksson (5/18/2015)
Revenant (5/18/2015)
crookj (5/18/2015)
SQLRNNR (5/18/2015)
pompspectacle
eyeglass
Sight
Line
Manager
May 18, 2015 at 1:47 pm
Revenant (5/18/2015)
crookj (5/18/2015)
SQLRNNR (5/18/2015)
pompspectacle
eyeglass
Sight
May 18, 2015 at 1:42 pm
Jeff Moden (5/18/2015)
Just so that everyone knows, this does not work in a clustered environment.
Quick question Jeff, would restoring the latest master be of any help, IIRC the Min-Max-Mem values...
May 18, 2015 at 1:22 pm
newbieuser (5/18/2015)
We are getting an error for the below query via application program, it works from the database. Wondering if it is possible to tweak the SQL...
May 18, 2015 at 12:42 pm
xizwyck (5/18/2015)
May 18, 2015 at 12:31 pm
rattil (8/18/2009)
I'm in the process of converting Oracle materialized view to SQL indexed view. This view has following analytical...
May 18, 2015 at 12:06 pm
New Born DBA (5/18/2015)
May 18, 2015 at 11:50 am
TomThomson (5/17/2015)
It's a bit surprising how many have it wrong so far (more than half) because the four functions in the three wrong options have all been around since...
May 18, 2015 at 11:39 am
Just piling on a bit, did you have a look at SQL Server Best Practices Article
and of course Microsoft® SQL Server on VMware®
Best Practices Guide?
😎
May 18, 2015 at 11:21 am
dwain.c (5/17/2015)
Jeff Moden (5/17/2015)
I don't understand why people post such questions instead of just trying it.
That's what I would do.
Of course, then Eirikur would have no fun posting...
May 18, 2015 at 11:09 am
GilaMonster (5/18/2015)
Almighty (5/18/2015)
Adjust the max memory of sql server to 80 % of total memory and so that you wont face the issue again
If you look at his original post,...
May 18, 2015 at 11:01 am
Martin 45512 (5/13/2015)
DECLARE @table TABLE (XMLData XML);INSERT INTO @table
SELECT *
FROM OPENROWSET(BULK N'C:\XML\Table1.xml', SINGLE_BLOB) rs;
Quick thought, no need to use the table variable
😎
;WITH SOURCE_DATA AS
(
SELECT
...
May 18, 2015 at 1:11 am
Jeff Moden (5/17/2015)
I was looking at the title of this post and thinking "Hmmmm, some XML that's actually space efficient". 😛
The ultimate compression!
😎
May 18, 2015 at 1:10 am
Viewing 15 posts - 5,251 through 5,265 (of 8,761 total)