Viewing 15 posts - 106 through 120 (of 392 total)
Paul White
Fair enough. I quite like Brandie's suggestion to lock it though
Let me show my ignorance, what is the difference?
If lock it means that it is visable but unable...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
January 13, 2012 at 9:17 am
Paul White
What's the general feeling about asking Steve to remove that "Question for the Experts" thread?
If one has a vote, and all votes are equal, I would say no.
I think...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
January 13, 2012 at 7:38 am
Peter
What is the contents of the @phonenum variable?
The variable contains a telephone number. In this case, it could be a cell, home or work phone. The reason for the like...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
January 12, 2012 at 9:58 am
Unfortunately the use of wild cards before and after a string using like will force a table scan which can be problematic.
What I have done in the past is to...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
January 12, 2012 at 9:31 am
A
Bex
imho (and I may be very wrong), I got the impression the op was almost suggesting that some people post replies asking questions as a form of ego, whereas...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
January 12, 2012 at 7:15 am
We too do a lot like this with full text indexing as well. Amazing speed.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 22, 2011 at 8:10 am
There are a few jobs besides those for the replication agents that run. Some of these run every 10 minutes and perform things like reindexing, defragmentation and aging. They will...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 22, 2011 at 7:05 am
More light reading that may be of help:
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 19, 2011 at 9:31 am
Have you considered the possibility of transactional replication?
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 14, 2011 at 9:58 am
Good question Hugo. Kept looking for the catch, and kept re-reading to find there is none:-P
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 2, 2011 at 6:52 am
Using openrowset will allow you to perform selects between servers that are not using linked servers. We do this amongst many servers on our network. We do this because if...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
November 8, 2011 at 9:06 am
Elliot
Amen, no matter how much I have learned there is an infinite amount I still have to learn. And the smartest people I know, know what they DON'T know.
So true...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
November 2, 2011 at 5:05 pm
Adam
And just for the record, the stop being elitist comment was aimed in general to this thread. Some of the posts are so arogant and close-minded and interestingly enough, not...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
November 2, 2011 at 6:34 am
Adam
Stop being so elitist
Didn't realize that I am being elitist.
Yes, I am a Sr DBA - why? Because my company says so. What makes me one, act of a VP....
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
November 2, 2011 at 6:16 am
adb
Would you expect your junior DBA to know about disk partition alignment, NTFS cluster size, RAID types,
TempDB - placement and number of datafiles, NUMA, instant file initialisation, AWE, locking...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
November 2, 2011 at 5:29 am
Viewing 15 posts - 106 through 120 (of 392 total)