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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy