Viewing 15 posts - 14,851 through 14,865 (of 14,953 total)
Reginald J Ray Jr (1/16/2008)
- 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 16, 2008 at 12:21 pm
If you are worried about moving all the files correctly, write the file moves as a .BAT file before-hand, then run that once you have detached. That becomes your...
- 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 15, 2008 at 8:39 am
Parameterizes sp_executesql! Of course! (I knew I was saying something stupid in my prior post on this one.) Yeah, do that.
- 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 15, 2008 at 8:30 am
Jeff Moden (1/14/2008)
- 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 15, 2008 at 8:26 am
A bat with a nail? How primitive! I want a taser, preferably with a laser-sight on it (even if it doesn't work at a distance)! I have...
- 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 15, 2008 at 8:23 am
On index names, I use a three-character code to indicate the type of index, then the table name, then a description, separated by underscores.
E.g:
IDX_Customers_Name on dbo.Customers(LastName, FirstName, MiddleName)
CID_Customers_Name on dbo.Customers(LastName,...
- 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 15, 2008 at 8:16 am
I use camel-case for table names, and use underscores in the names of procs where I would use a period if it were an OOP language.
For example:
Customers
CustomersEmail
would be tables. ...
- 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 15, 2008 at 8:09 am
Of course, my solution only works if the table definition is different depending on what the variables do in the IF statements.
If you have a single table definition, just define...
- 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 15, 2008 at 7:56 am
The only way I know to do this is to define the temp table before the IF statement. Here's an example that might work for you:
create table #T1 (ID...
- 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 15, 2008 at 7:54 am
Please see:
http://www.simple-talk.com/sql/t-sql-programming/the-helper-table-workbench/
for a better way to accomplish this same task (and a few others). It's faster, and takes less CPU resources.
- 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 15, 2008 at 6:15 am
I haven't had to solve this before, so there might be a better solution, but here's a suggestion that might work.
In the calling procedure (the one that builds the SQL...
- 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 14, 2008 at 2:21 pm
Keep in mind that the one with "between" will be much easier on the server than the ones that have functions in the Where clause.
Also, unless you've already handled this...
- 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 14, 2008 at 2:13 pm
Some employers expect more than 40 per week, but with poor reason.
The 40-hour week isn't arbitrary. If you look at the history on it, extensive experimentation and study have...
- 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 14, 2008 at 6:46 am
Apex tools I use and like: Diff, Log, Report, Doc
I have licenses for some of the others, but don't find I use them that much. Their Edit and Code...
- 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 11, 2008 at 4:51 pm
Redgate has some great tools.
Also check out ApexSQL (www.apexsql.com). Similar to Redgate. Some overlap, some differences, some it's hard to tell the difference without checking the logo.
- 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 11, 2008 at 1:02 pm
Viewing 15 posts - 14,851 through 14,865 (of 14,953 total)