Luis Cazares

Forum Replies Created

Viewing 15 posts - 3,241 through 3,255 (of 8,731 total)

RE: How to Split a a single Date into potentially hundreds of new date Values

GeoGym (3/3/2016)
Lynn,
I read the article on the tally tables and also worked though all of the examples. I do understand how tally tables are much faster than creating loops. However,...
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

March 3, 2016 at 1:41 pm

#1862918
RE: Today's Random Word!

Ed Wagner (3/3/2016)
Revenant (3/3/2016)
Grumpy DBA (3/3/2016)
djj (3/3/2016)
HappyGeek (3/3/2016)
Das boot
Submarine
Sammich
Bun
Big Bun (I hope someone remembers the reference)
Big Ben (I didn't :-D)
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

March 3, 2016 at 12:52 pm

#1862900
RE: Get previous and next records based on id from result set

Use a CTE or derived table to generate the LEAD and LAG before filtering.
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

March 3, 2016 at 11:27 am

#1862861
RE: execute multi level dynamic sproc

You can't execute a result set, you need to assign the text into a variable. Please, be very careful with SQL injection as this could be a recipe for disaster...
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

March 3, 2016 at 11:17 am

#1862854
RE: Many conditions - best practice

Here's an example on how to work with iTVFs, actually 2.
For more information about iTVFs and how they compare with normal scalar functions, check this article written by Jeff: http://www.sqlservercentral.com/articles/T-SQL/91724/
Here...
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

March 3, 2016 at 11:10 am

#1862852
RE: execute multi level dynamic sproc

Why are you doing that when you can do this
DECLARE @templogin NVARCHAR(128);
Set @templogin='domain\user1';
exec [DBA].[dbo].[CopyAllLoginsUsers] @loginholder= @templogin;
Especially when using NVARCHAR(MAX), you're exposed to SQL injection.
Use parametrized queries whenever possible. For...
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

March 3, 2016 at 9:52 am

#1862821
RE: Today's Random Word!

djj (3/3/2016)
Ed Wagner (3/3/2016)
Grumpy DBA (3/3/2016)
djj (3/3/2016)
ThomasRushton (3/3/2016)
Ed Wagner (3/3/2016)
BWFC (3/3/2016)
Luck
Skill
Rich
Poor
Pour
Pitcher
Baseball!
Beer
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

March 3, 2016 at 8:01 am

#1862766
RE: MS SQL vs Oracle

People who say that Oracle is the future are probably people that already work with Oracle or just got certified on Oracle. The truth is that I'd have more confidence...
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

March 3, 2016 at 7:30 am

#1862742
RE: How to create a Stored Procedure from this Code

Phil Parkin (3/2/2016)
Luis Cazares (3/2/2016)
Hugo Kornelis (3/2/2016)
The alternative, since this appears to be some type of ETL process to feed a DW table, would be to create an SSIS package.
That...
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

March 2, 2016 at 1:22 pm

#1862557
RE: How to create a Stored Procedure from this Code

Hugo Kornelis (3/2/2016)
The alternative, since this appears to be some type of ETL process to feed a DW table, would be to create an SSIS package.
That tool is specifically built...
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

March 2, 2016 at 1:05 pm

#1862549
RE: Project ideas for DBA to advance in powershell

Did you see this thread?
http://www.sqlservercentral.com/Forums/Topic1765816-2799-1.aspx
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

March 2, 2016 at 12:13 pm

#1862517
RE: Free eBook today: SQL Server 2012 with PowerShell V3 Cookbook

Thanks for posting, Gary.
I understand why Hugo couldn't be sure of the legitimacy of your post. Just add a few words when sharing this valuable links to give some certainty....
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

March 2, 2016 at 9:00 am

#1862435
RE: Populating table of shifts

Why don't you store the pattern in a different table so you can just replicate it any times you need?
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

March 1, 2016 at 10:09 am

#1862149
RE: Migrate Control-M jobs to SQL Agent

I'm not really sure how to do it, but you're basically facing the migration from xml files to sql scripts. If you're able to convert the xml into relational data,...
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

March 1, 2016 at 9:49 am

#1862145
RE: How to calculate a timeline and avoid using cursor

Here's an option that could help you achieve your goal. I'm not posting the full solution so you need to understand what's going on.
WITH
cteRows AS(
SELECT...
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

March 1, 2016 at 8:56 am

#1862127

Viewing 15 posts - 3,241 through 3,255 (of 8,731 total)