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...
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.
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.
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...
December 15, 2011 at 6:55 am
IceDread (12/15/2011)
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.
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...
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....
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...
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...
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 *...
December 14, 2011 at 2:44 pm
I like this sequence of posts! (The two before this one.)
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...
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...
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...
December 14, 2011 at 1:27 pm
Viewing 15 posts - 2,611 through 2,625 (of 14,953 total)