Luis Cazares

Forum Replies Created

Viewing 15 posts - 2,926 through 2,940 (of 8,731 total)

RE: An attempt was made to set a report parameter

Did you modify the report? Or just the call?
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

May 2, 2016 at 10:43 am

#1875942
RE: Today's Random Word!

DonlSimpson (5/2/2016)
whereisSQL? (5/2/2016)
Ed Wagner (5/2/2016)
Grumpy DBA (5/2/2016)
eccentricDBA (5/2/2016)
Ed Wagner (5/2/2016)
Grumpy DBA (5/2/2016)
crookj (4/29/2016)
whereisSQL? (4/29/2016)
Freak
Quasimodo
Hunchback
Notre Dame
Fighting Irish
Rudy!
New York
Yankees
Rebels
Empire
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

May 2, 2016 at 9:45 am

#1875932
RE: What is the difference between SSRS and Power BI

SSRS is meant for "static" reports. Something that will be shown always as defined. It's great for reports that should be printed. It usually requires some technical skill when modifying...
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

May 2, 2016 at 8:54 am

#1875918
RE: 16 core and sql server enterprise license cost

You would get better help about licensing if you contact Microsoft directly. Anything said in this forum would be unofficial and possibly different from the real options you have.
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

May 2, 2016 at 8:45 am

#1875916
RE: Using reserved words as column names

j-1064772 (5/2/2016)
Luis C.
Could not repress a smile when I saw you dropping the bloody database at the end ...:-)
I wouldn't want to keep that. I might actually use it 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

May 2, 2016 at 8:36 am

#1875913
RE: Using reserved words as column names

Sioban Krzywicki (4/29/2016)
Eric M Russell (4/29/2016)
If you really want, you can also model an entire database containing objects with only spaces for names.
create database [ ];
GO
use [ ];
GO
create...
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

May 2, 2016 at 8:17 am

#1875907
RE: creating a view in SSRS?

There's no need to create a view from SSRS. A view is simply a named query. You should be creating a stored procedure in the server and call the stored...
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

May 2, 2016 at 8:00 am

#1875903
RE: Cannot specify a column width on data type ntext - SQL Server 2014 Enterprise (64 bit)

ntext doesn't have a length definition. It has a predefined maximum size.
You should stop using ntext and start using nvarchar(max). It has the same capabilities and it's easier to manage....
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

May 2, 2016 at 7:48 am

#1875897
RE: Is there any way to show CAPS lock status in SMSS like we have in MS Word?

CAPS lock is affected system wide, so the indicator in the keyboard should be enough.
If there's no indicator in the keyboard, there's usually an icon next to the clock.
Why would...
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

May 2, 2016 at 6:41 am

#1875867
RE: Selet for syntax in whole database

I've found this tool very useful.
http://www.red-gate.com/products/sql-development/sql-search/
(I don't work for Red-Gate)
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

May 2, 2016 at 6:37 am

#1875866
RE: Looking for a best DBA tool

You would need to be specific on what you need. Design? Monitoring? Automation?
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

April 29, 2016 at 1:30 pm

#1875704
RE: Geting a lot of dups

You need to comment all tables and the uncomment each table at a time. Or go the other way, comment one table at a time and see which one would...
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

April 29, 2016 at 1:24 pm

#1875702
RE: Query Result

Something like this?
SELECT DISTINCT
CASE WHEN MAX(Criteria) OVER( PARTITION BY ServiceName) <> MIN(Criteria) OVER( PARTITION BY ServiceName)
...
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

April 29, 2016 at 1:11 pm

#1875697
RE: Geting a lot of dups

Review which table is causing the dupes and remove them there before doing the join. In other words, use a subquery or temp table if necessary.
Check Date is the same...
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

April 29, 2016 at 1:01 pm

#1875695
RE: Are the posted questions getting worse?

Brandie Tarvin (4/29/2016)
Grant Fritchey (4/29/2016)
Brandie Tarvin (4/29/2016)
So a coworker attended a gender diversity workshop. She forwarded me the presentation with a slide that says women constitute 40% of database administrators,...
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

April 29, 2016 at 12:28 pm

#1875682

Viewing 15 posts - 2,926 through 2,940 (of 8,731 total)