Viewing 15 posts - 6,166 through 6,180 (of 14,953 total)
Not a waste of time. Use what works best for you.
- 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
November 9, 2010 at 2:43 pm
SSMS doesn't do that.
You could still use Access for it, so far as I know.
Or you'll be building your own front end.
SSMS is really meant for DBA work, like managing...
- 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
November 9, 2010 at 2:41 pm
There are tables in the execution plan that aren't in the query, probably because they're in the view. Can you post the view definition? Ideally, the table DDL...
- 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
November 9, 2010 at 2:23 pm
Mike Caldwell (11/9/2010)
Fingerprints are passwords. They're both just data to a CPU. The rules for one are the rules for the other.
Fingerprints are non-deterministic passwords.
The hash of the...
- 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
November 9, 2010 at 1:27 pm
Nope. I've done that, and never seen an issue. Unless by "multiple" you mean hundreds or thousands, which might eat a few too many 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
November 9, 2010 at 1:23 pm
VBA (Visual Basic for Automation) is designed for exactly that kind of thing. You can program an Excel sheet to pull from SQL, push to SQL, pivot on 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
November 9, 2010 at 1:22 pm
Can't really help on this without a copy of the execution plan.
What's the problem with the join method? Is the query unexpectedly slow?
- 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
November 9, 2010 at 1:19 pm
Sean Lange (11/9/2010)
- 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
November 9, 2010 at 1:11 pm
Mike Caldwell (11/9/2010)
the fingerprint software must have saved an unencrypted version of the key material (i.e. your password) somewhere in order to present it to the OS and log you...
- 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
November 9, 2010 at 1:10 pm
Try a join instead of a string function buried in a UDF.
IF OBJECT_ID(N'tempdb..#Patterns') IS NOT NULL
DROP TABLE #Patterns;
CREATE TABLE #Patterns (
Country CHAR(3),
Pattern VARCHAR(100));
INSERT INTO #Patterns
...
- 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
November 9, 2010 at 1:07 pm
rko.37gags (11/9/2010)
Plz post me the query.....i didnt understand ur "Blah Blah"
The troll speaketh!!
- 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
November 9, 2010 at 12:47 pm
Security is always about the cost of obtaining it vs the value of what can be obtained.
If the data you have access to is valuable enough, you have to assume...
- 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
November 9, 2010 at 12:22 pm
You can set one of the options for replication to not include schema changes.
But even if you do, what happens when someone adds or changes a column in one of...
- 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
November 9, 2010 at 10:51 am
Kit G (11/9/2010)
GSquared (11/9/2010)
Alvin Ramard (11/9/2010)
GSquared (11/9/2010)
Chad Crawford (11/9/2010)
Edited. Decided there was no good point to my post.Like about half the questions/posts on the forums, eh?
Especially in The Thread.
Speaking...
- 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
November 9, 2010 at 10:46 am
Is the XML split across files, or just pages within the files?
If it's just pages within the files, take a look at OpenRowset Bulk Single_CLob in Books Online or MSDN....
- 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
November 9, 2010 at 10:44 am
Viewing 15 posts - 6,166 through 6,180 (of 14,953 total)