Viewing 15 posts - 2,161 through 2,175 (of 15,381 total)
g.britton (10/29/2015)
For that matter I wish we had true Boolean variables. But I dream.
We do.
create table MyTrueBoolean
(
TrueBool bit not null
)
If you have a bit column and no value is...
October 29, 2015 at 2:07 pm
New persopn (10/29/2015)
I just want to capture the below information through SQL script.
SQL Server Name
Number Of Instances
Number of Databases and size
Service account details
RAM
CPU
ANY HA is configured for databases like...
October 29, 2015 at 10:55 am
seware74 (10/29/2015)
October 29, 2015 at 10:00 am
ChrisM@Work (10/29/2015)
Ed Wagner (10/29/2015)
yb751 (10/29/2015)
I was thinking about unleashing it but then I...
October 29, 2015 at 9:18 am
Ed Wagner (10/29/2015)
yb751 (10/29/2015)
I was thinking about unleashing it but then I thought...
October 29, 2015 at 8:58 am
Uri.KlilHahoresh 86084 (10/28/2015)
Well, I answered 5 because 3 was not an optionas usuall the correct answer is "depends..."
if database is case sensitive then the answer should be 3!
As has always...
October 28, 2015 at 10:37 am
ChrisM@Work (10/28/2015)
Sean Lange (10/28/2015)
kat35601 (10/28/2015)
.......
Then you have inequality conditions in you where clause. This is nonSARGable and prevents index seeks.
...
Not always:
CREATE TABLE #MyTable (ID INT IDENTITY(1,1) NOT NULL, Inequality...
October 28, 2015 at 10:33 am
kat35601 (10/28/2015)
"redtag='Y"
omit items like
"OrbeData_KithKitchens.dbo.WIP_master.STATUS not IN ('1','25','50')"
I also want to omit items that have a status...
October 28, 2015 at 10:01 am
sarath.tata (10/28/2015)
October 28, 2015 at 9:50 am
sarath.tata (10/28/2015)
CREATE TABLE Person
(
PersonID INT
Name varchar(50),
HireDate datetime,
HireOrder int,
AltOrder int
)
Assume I have data like this
INSERT INTO Person VALUES(1, 'Rob', '06/02/1988', 0, 0)
INSERT INTO Person VALUES(1, 'Tom', '05/07/2016',...
October 28, 2015 at 8:55 am
Ed Wagner (10/28/2015)
Chris Wooding (10/28/2015)
Does that mean I get a toaster now?I'm holding out for the SSC T-shirt. 😛
I know!!! I would wear one. I have a ms-sql tips shirt...
October 28, 2015 at 8:33 am
below86 (10/28/2015)
Sean Lange (10/28/2015)
below86 (10/28/2015)
Sean Lange (10/28/2015)
Roshan Oozeer (10/28/2015)
Correct answer is 5 not 4 ... I want my 2 points.... Thank youRoshan
You just got one of them. If you want...
October 28, 2015 at 8:13 am
below86 (10/28/2015)
Sean Lange (10/28/2015)
Roshan Oozeer (10/28/2015)
Correct answer is 5 not 4 ... I want my 2 points.... Thank youRoshan
You just got one of them. If you want points that badly...
October 28, 2015 at 7:46 am
Roshan Oozeer (10/28/2015)
Correct answer is 5 not 4 ... I want my 2 points.... Thank youRoshan
You just got one of them. If you want points that badly you can have...
October 28, 2015 at 7:25 am
Luis Cazares (10/27/2015)
yb751 (10/27/2015)
Awesome solution Luis, I'm going to keep this one for a rainy day. Just curious why you created a @date_serial variable. Is it needed?
Yes, it's...
October 27, 2015 at 2:13 pm
Viewing 15 posts - 2,161 through 2,175 (of 15,381 total)