Viewing 15 posts - 76 through 90 (of 229 total)
squvi.87 (4/29/2016)
Any example driven links to learn the xml querying techniques?
I'll second that !
April 29, 2016 at 9:30 am
...gotta add the N'{whatever}' to make sure it's nvarchar.
Ach Soooo ! That's a new one for me. The only time I was using the "N thing" was in something...
April 29, 2016 at 9:00 am
Sioban Krzywicki (4/28/2016)
April 29, 2016 at 8:25 am
The C# bit I got from a colleague at the office who has considerably more experience than I do.
He was referring to the specific cases a dictionary structure so that...
April 21, 2016 at 10:39 am
First, you can make life easier for yourself by using aliases.
It is already bad enough that all your column names are in ALL CAPS (shouting ?)*** you can at least...
April 21, 2016 at 9:36 am
[font="Comic Sans MS"]"Database servers are generally bottlenecked enough as it is ..."[/font]
That is an all-encompassing statement. Which has its limits.
Forcing DB servers to disgorge the entire contents of a large...
April 21, 2016 at 9:11 am
All the solutions proposed are interesting.
However, would it not just be simpler to - as proposed by OP - to just store the MAX(date) into a local variable and simply...
April 21, 2016 at 8:13 am
drew.allen (4/18/2016)
[snip]
ROW_NUMBER() is deterministic as long as the ORDER BY clause is deterministic.
Alan.B (4/18/2016)
[snip]
In other words, when the columns referenced in your the ORDER BY portion of your OVER clause...
April 19, 2016 at 7:48 am
GilaMonster (3/29/2016)
Space used + 2 bytes.... The longest city name in the world is 176 characters (and that city is usually written with a much shorter name - Bangkok)...
Just curious...
April 14, 2016 at 8:31 am
MadAdmin (4/5/2016)
VIEW\Template Explorer OR Ctrl+Alt+T
and you will have a list of most stuff.
So you dont have to remember syntax of how to create table, index,...
April 5, 2016 at 1:02 pm
Having never looked at deadlock issues, I find the whole script somewhat hard to digest.
May I suggest expanding the article to include a short introduction to Extended Events and how...
April 4, 2016 at 9:18 am
kenambrose (3/10/2016)
[[If you deal with a report and want all columns via left joins, then there will be nulls. ]]
We don't know...
March 10, 2016 at 12:53 pm
Does not this suggest that legal entities should be in a different table instead of mixing legal and moral persons ?
March 4, 2016 at 9:48 am
Sorry guys. Neither of you appear in the other thread.:blush:
Certainly blew up in my face.
One lesson about the danger of cross-threading.
March 4, 2016 at 9:14 am
Viewing 15 posts - 76 through 90 (of 229 total)