@swasheck Really? When DK was leaving them, he said they were shifting from support for both SQL Server and Oracle to Oracle exclusively. Maybe the pendulum has swung back
I have big log4net database table with this structure.
CREATE TABLE [dbo].[Log]
(
[Id] [INT] IDENTITY(1,1) NOT NULL,
[Date] [DATETIME] NOT NULL,
[Thread] [VARCHAR](255) NOT NULL,
[Level] [VARCHAR](50) NOT NULL,
[Logger] [VARCHAR](255) NOT NULL,
[Application] [VARCHAR]...
@MaxVernon Thanks. I was inspired by your idea of the indexed view :). The np computed column with nc index seems like a natural fit that doesn't require converting on the fly but still simply fits into the OP's query. And long weekend? I have been sick for 5 days now and missed giving a SQL Saturday presentation, but still had to help with my daughter's 3rd birthday party on Sunday..so yes, VERY long :(
@srutzky Ouch! Up here in Canada, it was Thanksgiving yesterday. Not much time to get on the DBA site!
I Hope you feel better!
@srutzky I have never tried a nc index on a non-persisted computed column before, so thank you!
If the QO decides to use the index, that's certainly a win.
This is what happens when you use your mobile to look at questions and then see Gordon in there. I should have read the other answer I reference a little more closely, cuz I missed the INNER.
How is this materially different from the first answer, posted by Juan Carlos Oropeza? — Max Vernon2 days ago
I just saw this in the low-quality review queue. The system said is was identified as possibly spam. It doesn't seem like spam so much as a person who talks like a markov chain generator.
From my readings, I still not understand what is this Classification and why does it need to have the ID_Company. If it's like a position as someone mentioned here, I'd think a static table to contain all positions would be better.
If you are doing this in order to easily find a classification/p...
@MaxVernon Thanks. I'll get there eventually. And don't worry, your mis-read due to skimming that code is more effort than G.Dawg (or "flash"?) is willing to put in.
@PaulWhite as it relates to the following answer, and edit you just made on it:
I tried PartitionDB* yesterday. Basically, from my understanding, it takes DPV (Distributed Partitioned Views) and does the work for you, maybe one of their union examples will work for you.
Note, you need to gather that shard/partition field ready in all your sharded/partitioned tables.
* I am...
Are you sure that he is a beta user and not their support guy: http://partitiondb.com/forums/users/jonapartitiondb-com/replies/ ?? Just asking due to similarity of name, though I realize that "John" is fairly common ;-).
Coming back to this WAY late. Still, we've been pondering and testing the use of shrink in our testing environments for a long time as well. As per the topic, there are times when shrink is a viable option. But knowing when and how to apply it, are vital to proper execution both in the long and s...
> Especially since contrary to some articles around the web, the size of your data files DIRECTLY CORRELATES WITH BACKUP / RESTORE DURATION. That's because unlike many articles assume, real life scenarios have loads more data on any given page than just the stuff you've maybe removed.
Anyone have issues with TF3688 (the one that turns off 'SQL TraceID 2 was started by...')? It's enabled globally on my server and is in the startup parameters but I'm still getting those message logged to the error log. SQL 2014, EE, SP1.
I have a stored procedure that is used for inserting the values in two tables.
Both tables has parent child relationship i.e. First table has identity column and second table has a referenced column of first table. In this procedure I am returning Scope_Identity() value to a column. Below is the ...
Some people's train of thought, hard to understand is.
@ypercube why do you assume they're not. If they edit a country tag in, some answers will become out of date; but if we were to limit answers to those that only cover things that are true in every jurisdiction, they'd be woefully incomplete in almost all of them. If we limited answerers to people who know the laws well in numerous jurisdictions, we'd massively reduce the number of people who can answer. — Dan Neely2 hours ago
@billinkc - I honestly don't think it has anything to do with the version of SSIS, nor with using a package or project deployment model, or with what kind of exception the stored proc is getting. I will update the question with a sample query. It has to do with the behavior of "OnError" eventhandler in SSIS and PRINT statements used in a query. — Nanu1 min ago
Their proc is always generating output. But they only ever look at the output of the proc when there's an error and so they think it shouldn't be capturing it
the cross joins are turned into inner joins with the where clause FFS
user58869
hello, please help me understand this, in mssql, if i have cascade delete set on a column in the table definition will it delete rows in the other table or this table?
Talked with an old coworker yet. Seems there's a limit of 1000 parameters in SSRS and he met it. Well, the default threshold is 1k parameters but you can adjust the settings in reporting services to allow for more.
I did not want to know what abomination he was birthing
@Zane ha, reminds me of an enormous query I was asked to tune for an SSRS report a BA made a while back. The ticket response I posted was "can you give me the specs for the report so I can recreate the query/report" and I never heard anything back from him
seems sqlfiddle is not up to this task. Can anyone verify if the recovery_model_desc column in sys.databases has a collation of Latin1_General_CI_AS_KS_WS ? I've been using this code to look at it (2012+)
USE master;
SELECT d.name
, d.collation_name
FROM sys.databases d
WHERE d.name = 'master';
DECLARE @cmd NVARCHAR(MAX);
SET @cmd = 'SELECT recovery_model_desc
FROM master.sys.databases d;';
EXEC master.sys.sp_describe_first_result_set @tsql = @cmd;
I don't understand why the collation of that column is not the database-default collation since it is a simple nvarchar(60) column that only ever contains the name of a valid collation. All databases on this instance are in the "standard" collation of SQL_Latin1_General_CP1_CI_AS
Yeah you need to explicitly add COLLATE statements whenever using union, pivot, etc. against multiple databases
I forget often because I set up pretty generic systems on purpose, but people who take my code and put it in their systems always let me hear about it.
@AaronBertrand lol, no doubt. I wish it said something like The collation of column "PageVerify" conflicts with the collation of other columns specified in the UNPIVOT list.
Well way back when it actually meant "lower priority" rather than "this is a terrible idea"
I down-voted quite a few of my own suggestions when you could do that - not because I thought I had a bad idea but because there were other, more important issues to fix.
Many of my suggestions have always been nice to haves that I hope they eventually get to when they're in that part of the code and don't have to worry about breaking compatibility.
No worries, I really do think the Stack Exchange mindset has overtaken the priority mindset, and people down-vote only when someone files a stupid Connect item, like select without order by produces "incorrect" order
Or a duplicate, have seen down-votes on those, too
Well I'll take "slower queries over errors" for 1000, Alex
I doubt they will do anything about the behavior of 2363 now, more likely they will introduce yet another undocumented and unsupported trace flag that breaks less
@AaronBertrand well 2363 is a verbosity thing ... doesnt help query performance. but yeah, i disabled it, but figured i'd submit it just so that it's documented
fair enough --- and, especially if it's an unsupported flag, --- CUT IT OUT is an appropriate response. just figured someone may be as dumb as me in the future :)
My grandfather was a doctor and got drafted as a medic in the army. The shit they came up with to get out of combat was amazing, he had so many stories. The one that stuck was lots of folks coming into his tent and saying "I can't lift my arm past here." He'd ask, "how high could you lift it before?" They'd raise their arm up over their head, and he'd say "get the f* back on the field."
@JamesLupolt ... kevin kline and kendall van dyke did the orientation for me. kevin's a good guy so i dont want to disparage the event too much. kendall is ... from orlando. that's what i know about him.
The first timers orientation session used to be lead by ... some guy who actually knows what he's talking about. Still a bit awkward but it's at least a professional trying to help break the ice.
It's not really a good deal, and even less so for those instructors who pay their own way, hotel, food, etc.
In Belgium I did the pre-con in exchange for a highly reduced ad/sponsor rate for the company. So I got $0 but felt less ripped off than I do for PASS Summit.
@MikeFal yeah even a SQL Saturday pre-con is really pretty good, I mean $/head is about the same but there isn't this big lump of overhead going to someone else
That is interesting to me that speakers aren't paid and/or get free lodging when they speak. I always assumed lodging at Super 8 or the like was standard. For SQL Saturday it makes more sense not to get paid since the event is free, but still....
@Erik SQL Sats aren't such a big deal, it's always been understood that speakers volunteer and pay their own way. Happy to do it, even for precons. I certainly didn't give precons this year out of a need to make money, simply to give a full day preso and help offset some costs.
Summit is a little more....annoying, considering the size of the event, attendance, and costs. They don't have to pay for more than half the speaker base, which is the main point of the conference. That's a pretty significant savings for them.
@MikeFal That makes more sense for a free event, but for a paid event that is rubbish. Where could all the money go? I'm sure the directors aren't literally stuffing their pockets, but still it feels wrong
My assumption, which might be 100% false, is that the local chapters don't get much financial support from HQ. The venue/space for the monthly meetings are probably donated, and recruiters pay for the snacks. The monthly meeting speakers surely don't get paid either. The biggest expense on the local chapters seems to be hosting SQL Saturday's, but sponsors probably pay most of those costs for that.... Its probably just blatant ignorance on my end but I don't understand where the money goes.
@MikeFal denver.sqlpass.org that site can't cost that much. Regardless I'm sure people aren't actually pocketing the money, and they're doing lots of good things with that money that I don't see.
@swasheck I'd support either @AaronBertrand or @PaulWhite. They both have the name recognition, and I think they would both have the desire to serve the community over special interests. That being said I doubt they want the job.
I have big log4net database table with this structure.
CREATE TABLE [dbo].[Log]
(
[Id] [INT] IDENTITY(1,1) NOT NULL,
[Date] [DATETIME] NOT NULL,
[Thread] [VARCHAR](255) NOT NULL,
[Level] [VARCHAR](50) NOT NULL,
[Logger] [VARCHAR](255) NOT NULL,
[Application] [VARCHAR]...
it takes time , Field, results and scoring. what is the best to make it . I do it with firebird but I need a good attitude.
Who can help me?
