Viewing 15 posts - 5,266 through 5,280 (of 8,761 total)
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
ankithimmatlalshah (5/15/2015)
I would like to deploy one SSIS package at SSISDB database at SQL server 2014. This package is common for multiple clients and a separate SQL job needs...
May 16, 2015 at 4:38 pm
Overheard on the commute: "RedGate's backup" "Is it?"
😎
May 16, 2015 at 4:28 pm
GG_BI_GG (5/15/2015)
I have lot of package that execute in a sequence container, but is strange that the other package works and some other not. why?? Look my picture.
What are the...
May 16, 2015 at 4:20 pm
GilaMonster (5/16/2015)
Eirikur Eiriksson (5/16/2015)
a) SQL Server 2008 is a rather old product, consider SQL Server 2014 or 2016 as that will already give you some advantage.Um....
Is it only me...
May 16, 2015 at 4:17 pm
GilaMonster (5/16/2015)
Eirikur Eiriksson (5/16/2015)
GilaMonster (5/16/2015)
Eirikur Eiriksson (5/16/2015)
a) SQL Server 2008 is a rather old product, consider SQL Server 2014 or 2016 as that will already give you some advantage.Um....
Point...
May 16, 2015 at 4:14 pm
wendy elizabeth (5/14/2015)
1. Users will enter data into an Access 2013 front end gui application...
May 16, 2015 at 4:11 pm
metroman17 (5/15/2015)
How do I capture Database connection failure errors.
Ex:
I am using select @@servername...
May 16, 2015 at 4:07 pm
Viewing 15 posts - 5,266 through 5,280 (of 8,761 total)