Viewing 15 posts - 7,051 through 7,065 (of 39,754 total)
Just because I think this is helpful, I wrote a tSQLt test for this. If you give it a try, you might find it's easy to test lots of cases...
February 24, 2017 at 1:12 pm
Crazy, revenge on employers rarely works out well for anyone.
February 24, 2017 at 11:48 am
PoSh or BCP, either work well. Keep it simple.
February 24, 2017 at 9:57 am
What's an active passive cluster? You need to be explicit here.
If you have:
- Server A, 4 cores, active node
- Server B , 4 cores, active node
February 24, 2017 at 9:57 am
I'm not sure what to do with pace. When I'm at games, it doesn't seem like warmups are longer between innings, which are commercial time. I would like to see...
February 24, 2017 at 7:39 am
I absolutely use a tally table, but I may use a smaller one than the sysobjects cross sysobjects one. I typically have a snippet of code that builds 1000 rows,...
February 23, 2017 at 7:02 pm
It's cold and snowy. That's the reason.
February 23, 2017 at 4:05 pm
I can't say it's my idea. I'm not sure if this was from Dwain Camps or someone else, but having the numbers there means I can easily do some math....
February 23, 2017 at 2:59 pm
No worries. I've done that a lot of times, wondering why SQL Server (or the compiler) doesn't just understand what I mean.
I didn't test this, preferring to go...
February 23, 2017 at 2:47 pm
You have a logical fallacy. "ReportServer" is not like "ReportServerTempdb". Same for the reverse. What you need is not like "ReportServer%" as one entry.
February 23, 2017 at 11:33 am
Wild pitches happen, but rarely. Most of the time the Intentional walk is annoying, at least to me. Speeding up the game matters, and anything they can do is good....
February 22, 2017 at 4:40 pm
The array issue seems to be the problem. I can create a condition that uses @name (for the database facet) = 'a' and then include an OR condition for @name...
February 22, 2017 at 9:25 am
While you could do this, I'd really go forward with something like ElasticSearch or Lucerne, which are better than SQL FTS.
February 22, 2017 at 9:12 am
As far as I know, there isn't any difference in how the SQL Server binaries and data files are organized between localized versions. There seem to be ways to get...
February 22, 2017 at 9:10 am
Please just click the flag icon to report. No need to post a note.
February 21, 2017 at 9:27 am
Viewing 15 posts - 7,051 through 7,065 (of 39,754 total)