Viewing 15 posts - 136 through 150 (of 380 total)
jarick 15608 (1/31/2015)
I've seen some big...
February 2, 2015 at 2:25 pm
How about using the dbtimestamp data-type as the Identity Column Value and Primary Key for Claim and Policy tables in an insurance database?
Can you guess what happened when they tried...
February 2, 2015 at 1:56 pm
mike.gallamore (1/26/2015)
January 26, 2015 at 9:25 am
Another reason why SELECT * from <any object> should never be used in application execution code.
We have two apps created by a Developer that swears this is fine.
Of course he...
January 26, 2015 at 8:04 am
How do you delete a duplicate from a Heap?
If the table is a true Heap with no PK and the records in every column match you would have to delete...
January 23, 2015 at 11:01 am
Eric M Russell (1/8/2015)
The good news is that Verizon cloud services isn't very popular, so the outage should impact only a small percentage of it's customers.
I did read...
January 8, 2015 at 8:14 am
If it goes down ever it is not a "cloud" service it is a remote service.
Cloud services are always on and should be redundant.
Verizon redefines the standard to match...
January 8, 2015 at 6:45 am
Jamie-2229 (12/28/2014)
Mostly, by way of English language flow. It is simple to say "Show me the stuff that isn't there or show me what you've got IN there." ...
December 29, 2014 at 7:25 am
Jamie-2229 (12/26/2014)
In my experience, MICROSOFT SQL SERVER application for NOT IN and IN is rarely applied the way it is intended.
This is what is so odd about what you...
December 26, 2014 at 8:58 am
Hugo Kornelis (12/26/2014)
Jamie-2229 (12/26/2014)
December 26, 2014 at 7:27 am
Jamie-2229 (12/26/2014)
Yep, you're right. <deleted incomprehensible data />... They are ugly.
Jamie - What are you even talking about? The IN and NOT IN operator have been around for 20+...
December 26, 2014 at 7:26 am
The importance of SET NOCOUNT ON in the all the user defined SPs is very important to get good performance.
False: If SET NOCOUNT ON is executed inside of...
December 12, 2014 at 1:45 pm
g.britton (12/9/2014)
select ...
from ...
where column in (@var)
and either:
1. put the base query in a view or TVF and...
December 9, 2014 at 3:00 pm
Nice simple article that covers ways to resolve what can be a very frustrating issue with SSRS.
Many developers and DBA's alike have a difficult time understanding the difference between passing...
December 9, 2014 at 7:35 am
Brian.Klinect (11/25/2014)
That's exactly what I did. I had no idea I could use a negative number for a datetime!
Since DateTime is stored as an Integer, it only makes sense...
November 25, 2014 at 8:12 am
Viewing 15 posts - 136 through 150 (of 380 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