Viewing 15 posts - 9,751 through 9,765 (of 39,882 total)
I'd learn to rebuild reports, trying different queries, and complex structures. Work on windowing functions, and learn to write queries that can easily summarize your data in new ways. Find...
May 20, 2015 at 5:24 pm
Disclosure: I work for Red Gate.
If you want to get Prompt and show it helps, I'd get some queries you normally write, and time the effort in Intellisense to reproduce...
May 20, 2015 at 5:22 pm
I'm late, but a few flaws. One, your questions table doesn't allow for separate surveys. If someone has a new survey they want, or change one, you can't "version" yours,...
May 20, 2015 at 5:10 pm
Shouldn't, but I'd need to test in SQL Azure. AFAIK, this means the user can only create tables in schemas they can control or access. If I create a new...
May 20, 2015 at 1:55 pm
Ah, didn't realize this was Azure SQL Database.
Setuser merely lets me change context. You could use two connections here. One does the granting of permissions as dbo/sa and the other...
May 20, 2015 at 12:00 pm
If you want to practice SQL, I'd suggest you take a few questions on this site, like this one: http://www.sqlservercentral.com/Forums/Topic1687195-3077-1.aspx
Only read the first post and try to solve it. If...
May 20, 2015 at 11:27 am
Your user has permission on the schema, but they don't have rights to create a table. They need CREATE TABLE permissions.
Here's a bit of test code:
CREATE LOGIN Com WITH PASSWORD...
May 20, 2015 at 11:17 am
Jeff Moden (5/19/2015)
I agree but why does one need the extra layer of tSqLt? DelimitedSplit8k even has two different tests built into the header so they won't get lost.
Automation....
May 19, 2015 at 9:06 am
Jeff Moden (5/18/2015)
I did say that most UDFs would never be updated, not all but, let's ask the question.How many UDFs that were already in production have you actually updated?
A...
May 19, 2015 at 9:05 am
Hugo Kornelis (5/19/2015)
TomThomson (5/19/2015)
The term "column elimination" doesn't appear to exist
It actually does (and I should have included it in my article).
Some references:
http://byobi.com/blog/2012/10/column%C2%AD-stores-for-wide-and-sparse-data/%5B/url%5D. (A blog I found when searching the...
May 19, 2015 at 8:56 am
Let's please be polite.
To giszzmo,
It's not completely clear what you are trying. It is helpful if you post some DDL and inserts for the data like this:
create table Grades
( SECTION...
May 19, 2015 at 8:44 am
I'm not sure I agree UDFs will never be updated. If not, I totally agree. Test once, leave alone.
I want testing for anything that will be refactored.
May 18, 2015 at 4:41 pm
I'm not sure I'd want the test conditions in a table, but that could work. Potentially managing lots of tests is cumbersome, though I haven't done enough large scale work...
May 18, 2015 at 3:34 pm
Good job, Lynn. I felt bad for the guy filling in for the DBA. That's a tough spot.
May 18, 2015 at 3:25 pm
Viewing 15 posts - 9,751 through 9,765 (of 39,882 total)