Viewing 15 posts - 2,341 through 2,355 (of 14,953 total)
SQL Kiwi (1/9/2012)
GSquared (1/9/2012)
Yes, but not at the posts count thing. Just at the "change your name to something even sillier than GSquared" thing.
You don't think 'Aaron Aardvark' has...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 9, 2012 at 10:43 am
Sounds like the best of my days.
Recently spent a significant amount of time solving a trivial database problem "the hard way". Beat on it till it worked. Could...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 9, 2012 at 10:40 am
The point of Agile is to allow business rules in the software to evolve as business rules in the business evolve.
There are ways to build a database to allow for...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 9, 2012 at 10:34 am
Aaron Aardvark (1/9/2012)
Brandie Tarvin (1/9/2012)
Try changing your screen name. Maybe that'll work. @=)Am I winning yet?
Yes, but not at the posts count thing. Just at the "change your name...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 9, 2012 at 10:26 am
SQLRNNR (1/9/2012)
GSquared (1/9/2012)
SQL Kiwi (1/9/2012)
I use spaces in my constraint and index names 😛I don't set a quantitative target on that.
Just like my naming standard of Caps on Consonants...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 9, 2012 at 10:01 am
SQL Kiwi (1/9/2012)
I use spaces in my constraint and index names 😛
And spell out table names as grammatically correct sentences, including punctuation?
create table dbo.[These are orders placed by our customers.]...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 9, 2012 at 9:59 am
Roy Ernest (1/9/2012)
When I get time post some thing,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 9, 2012 at 9:52 am
Jeff Moden (1/7/2012)
L' Eomot Inversé (1/7/2012)
Brandie Tarvin (1/6/2012)
At the risk of being virtually lynched, I can see the use in underscores in table names and especially in constraint names.
I use...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 9, 2012 at 9:46 am
My advice is collect performance metrics on both instances, and put together a plan based on those that will handle any meaningful performance bottlenecks or resource-depletion issues.
Start with gathering actual...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 9, 2012 at 9:38 am
Steve Jones - SSC Editor (1/6/2012)
User posts
SQLRNNR ...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 9, 2012 at 9:34 am
I'd be inclined to step outside of SSIS and use an SQL Script Object to query that. OpenRowset, with the Bulk and Single_CLOB options, will pull XML files into...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 9, 2012 at 6:42 am
I use server-side traces to do that kind of thing. Won't necessarily tell you who called a proc, if it's being called by a web-based application for example, but...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 9, 2012 at 6:39 am
Is it absolutely necessary to have SSIS output them for you? If not, you can use the object-scripting wizard in SSMS to generate table scripts any time you need...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 9, 2012 at 6:33 am
Ninja's_RGR'us (1/5/2012)
Steve Jones - SSC Editor (1/5/2012)
In terms of depreciation, it sucks, but it's real. The value of your stuff is lower over time, and if you had to replace...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 5, 2012 at 9:55 am
I would definitely NOT split it up that way. Split it within the database by schema, if you must split it up, but not accross multiple databases.
First, foreign key...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 5, 2012 at 9:51 am
Viewing 15 posts - 2,341 through 2,355 (of 14,953 total)