Luis Cazares

Forum Replies Created

Viewing 15 posts - 2,671 through 2,685 (of 8,731 total)

RE: Are the posted questions getting worse?

Brandie Tarvin (6/17/2016)
I knew I was conflating Whole Numbers and Integers somewhat, so I went and looked it up. Then my mind got blown.
ZERO IS NOT A RATIONAL NUMBER!
Further proof...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 17, 2016 at 8:05 am

#1885621
RE: Are the posted questions getting worse?

Ed Wagner (6/16/2016)
Lynn Pettis (6/16/2016)
Michael L John (6/16/2016)
Lynn Pettis (6/16/2016)
Michael L John (6/16/2016)
I'm sorry, this post infuriates me.
Integer division was taught within the first three weeks of my first...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 17, 2016 at 7:50 am

#1885614
RE: Hunting down bad code/ETL

Eric M Russell (6/16/2016)
In the past there was an ETL process where a standard deviation in record counts based on the previous X runs would flag the dataset in staging...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 17, 2016 at 7:38 am

#1885610
RE: Hunting down bad code/ETL

Lynn Pettis (6/16/2016)
JaybeeSQL (6/16/2016)
Hi all,
I'm leading a drive to get the code and ETL in our organisation reality-checked and improved, we'll be going to cloud soon and management acknowledge we...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 16, 2016 at 3:57 pm

#1885516
RE: Hunting down bad code/ETL

The first thing that comes to mind is SQLCop.
However, what you're trying to do might be an extensive work depending on your database and code quality.
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 16, 2016 at 2:19 pm

#1885502
RE: Interview Questions

Jeff Moden (6/16/2016)
timwell (6/16/2016)
Sergiy (6/15/2016)
My "Location" in the Forum Profile says "Auckland, New Zealand".
Current time in Auckland, New Zealand is 12:12 pm.
The "Posted" label indicates Today @ 1:12 am.
That's how...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 16, 2016 at 1:39 pm

#1885493
RE: Missing green arrow on the sql server icon in object explore

If you're missing the green arrow, this might help you: Get missing green arrow
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 16, 2016 at 12:54 pm

#1885485
RE: Today's Random Word!

Ed Wagner (6/16/2016)
crookj (6/16/2016)
djj (6/16/2016)
Ed Wagner (6/16/2016)
ZZartin (6/16/2016)
Luis Cazares (6/16/2016)
Ed Wagner (6/16/2016)
Igor Micev (6/16/2016)
Revenant (6/16/2016)
Grumpy DBA (6/16/2016)
Ed Wagner (6/16/2016)
crookj (6/16/2016)
Kansas
Kansas City
BBQ
Summer
Rio
Brazil
Argentina
Beef
Steak
Wooden
Vampire
Garlic
Onion
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 16, 2016 at 12:46 pm

#1885483
RE: Splitting an XML value into multiple rows

Check the code and explanation for the delimited splitter in here: http://www.sqlservercentral.com/articles/Tally+Table/72993/
Be aware that it's limited in length, so you need to be sure that you're not truncating anything.
Here's an...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 16, 2016 at 12:46 pm

#1885482
RE: Is there a way to determine if reports were created with Report Builder 1.0?

I'm not sure and I can't check right now, but you could look into the report file as xml to find if it's in the metadata.
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 16, 2016 at 11:55 am

#1885473
RE: Powershell script for SSIS 2012 build and deployment

Have you tried this?
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 16, 2016 at 10:30 am

#1885459
RE: Is there a way to extract certain parts of data

cory.bullard76 (6/16/2016)
And sorry if I wasn't clear....the field is called 'Strengthu' the examples I gave are the values. So, would I put Strengthu in the formula?
If you understand...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 16, 2016 at 9:34 am

#1885446
RE: Today's Random Word!

Ed Wagner (6/16/2016)
Igor Micev (6/16/2016)
Revenant (6/16/2016)
Grumpy DBA (6/16/2016)
Ed Wagner (6/16/2016)
crookj (6/16/2016)
Kansas
Kansas City
BBQ
Summer
Rio
Brazil
Argentina
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 16, 2016 at 9:04 am

#1885439
RE: Is there a way to extract certain parts of data

This could help you, too.
http://www.sqlservercentral.com/scripts/String+Function/141686/
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 16, 2016 at 8:49 am

#1885428
RE: Are the posted questions getting worse?

Brandie Tarvin (6/16/2016)
Everyone say goodbye to Texas. I do believe it's going to disappear soon. :w00t:
On a serious note, I'm really hoping no one gets hurt when this happens.
That's what...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 16, 2016 at 7:36 am

#1885393

Viewing 15 posts - 2,671 through 2,685 (of 8,731 total)