Viewing 15 posts - 2,611 through 2,625 (of 14,953 total)
That's not a SPID blocking issue. That means you need to issue a checkpoint, then rebuild the log. The problem isn't the presence of a checkpoint, it's 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
December 15, 2011 at 7:46 am
Any reason not to simplify this by using the XML datatype? Per the forum you posted in, you're using SQL 2005, which supports XML quite nicely.
- 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
December 15, 2011 at 6:58 am
Ninja's_RGR'us (12/15/2011)
@GS dude YOU'RE THE DEV :-D:hehe:
I think your sentence got truncated and lost a couple of letters.
- 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
December 15, 2011 at 6:56 am
Koen Verbeeck (12/15/2011)
GSquared (12/15/2011)
Koen Verbeeck (12/15/2011)
Back on topic again:http://www.sqlservercentral.com/Forums/Topic1222173-391-1.aspx
And it's with our personal favorite: the interview questions!
I especially like his replies. We're all fake (and not crazy?).
I answered all 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
December 15, 2011 at 6:55 am
IceDread (12/15/2011)
- 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
December 15, 2011 at 6:53 am
Koen Verbeeck (12/15/2011)
Back on topic again:http://www.sqlservercentral.com/Forums/Topic1222173-391-1.aspx
And it's with our personal favorite: the interview questions!
I especially like his replies. We're all fake (and not crazy?).
I answered all of his questions.
- 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
December 15, 2011 at 6:38 am
sqldba2k8 (12/14/2011)
Yesterday i attended the interview on sqldba position.they are asking these questions.please answer to these questions.1)what is your Daily work after entering into the office as a sql dba?
Drink...
- 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
December 15, 2011 at 6:35 am
Jim Murphy (12/14/2011)
GSquared (12/14/2011)
If something has been vaporized, it means it's been turned into vapor.Politicized = made political
Excized = Exed (removed)
So ... you've been turned into a scandal? :w00t:
Ah yes....
- 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
December 15, 2011 at 6:26 am
You won't be able to use a table variable in this case. The dynamic scripts will be out of scope for it.
As a general note, table variables are really...
- 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
December 15, 2011 at 6:24 am
engrshafiq4 (12/14/2011)
i am using ACE provider to insert bulk data from my web application to sqlserver.and the server do not support ACE provider.
Then you'll either need to use a different...
- 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
December 15, 2011 at 6:16 am
The example builds a string from a query.
Just run this part:
SELECT 'select * from [' + name + '].sys.tables;'
FROM sys.databases
If will give you a list that looks something like:
select *...
- 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
December 14, 2011 at 2:44 pm
I like this sequence of posts! (The two before this one.)
- 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
December 14, 2011 at 2:37 pm
Jim Murphy (12/14/2011)
Steve Jones - SSC Editor (12/14/2011)
SQLRNNR (12/14/2011)
Steve Jones - SSC Editor (12/13/2011)
SQLRNNR (12/13/2011)
About due for a Pantsectomy :-D:-D:-D:-D40F in Denver, no need for pants today.:-P
Just as long as...
- 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
December 14, 2011 at 2:37 pm
To clarify:
You can get a list of group names.
From that, you need to query computer names, but need the group name in an OpenQuery string, which can't use variables or...
- 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
December 14, 2011 at 1:56 pm
Yeah, the real product comparison will be to compare the features of each to the needs you have beyond simple schema comparisons.
One advantage to keep in mind with any 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
December 14, 2011 at 1:27 pm
Viewing 15 posts - 2,611 through 2,625 (of 14,953 total)