Viewing 15 posts - 5,251 through 5,265 (of 8,753 total)
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
audiocool (5/17/2015)
I have a new SQL Server 2012 (SP2 applied) installed in VM machine with OS Windows Server 2012.)...
Details Specification:
------------------------
OS: Windows Server 2012
RAM: 32GB
Processor: 4 core with 2.0Ghz
SQL Server...
May 18, 2015 at 12:49 am
For fun and furthering on Luis's answer, this examples brings back all primes between 10 and 100 using except.
😎
USE Test;
GO
SET NOCOUNT ON;
/*
For fun only, selecting all...
May 17, 2015 at 12:45 pm
As Jeff suggested, it is better to combine the two function calls and skip the temp table. Here are two variations, first one returns both the path and the file...
May 17, 2015 at 10:21 am
Quick suggestion, use the charindex and the revers functions.
😎
May 17, 2015 at 6:24 am
IIRC the GUID is calculated on a binary pattern including volatile attributes such as "Last Opened/Edited/Modified...", most likely the reason.
😎
May 16, 2015 at 4:53 pm
Sgar... (5/13/2015)
May 16, 2015 at 4:50 pm
naga.rohitkumar (5/15/2015)
How to track a sqlserver login if password changed how to know who has changed its a standard edition
we just want to check how and by...
May 16, 2015 at 4:44 pm
vipin_jha123 (5/15/2015)
I want to calculate the Hash value of below columns.
I have table having below columns
[Equipment_Id] + [EquipmentCompCode] + [EquipmentUnitNo] + [EquipmentSerialNo] + [EquipmentPlateNo] + [EquipmentExpireDate]+ [EquipmentState] + [EquipmentAxles]...
May 16, 2015 at 4:40 pm
Viewing 15 posts - 5,251 through 5,265 (of 8,753 total)