Viewing 15 posts - 14,641 through 14,655 (of 59,063 total)
July 28, 2017 at 11:03 am
BCP works fine with UNC's, as well. Don't use your server as a download repository even for staging a table.
July 27, 2017 at 1:54 pm
Another question... has someone made the mistake of pointing the synonyms to a linked server?
July 27, 2017 at 1:44 pm
July 26, 2017 at 5:19 pm
Thanks for all the replies. Problems with query store is that it fills up in minutes... (2GB query store). Anyway the vendor has provided a patch fix for...
July 26, 2017 at 5:13 pm
July 26, 2017 at 5:05 pm
SQL-DBA-01 - Wednesday, July 26, 2017 12:27 PMAlright. I just fixed it.
Two way street here... So what did you end up doing?
July 26, 2017 at 4:54 pm
See the following article.
http://sqlmag.com/sql-server/new-solution-packing-intervals-problem
July 26, 2017 at 4:50 pm
So do a row number with a partition by ID and a sort by date with a criteria of "not available" in a CTE and then select from the CTE...
July 26, 2017 at 4:41 pm
July 26, 2017 at 3:57 pm
July 26, 2017 at 2:38 pm
It actually serves a very important function... troubleshooting. It's useless inside a proc but if someone is trying to troubleshoot the code in the proc, then it's nice to have...
July 26, 2017 at 8:44 am
I renamed my wireless router "VirusTesting2". It's amazing how the hits on it have diminished.
July 25, 2017 at 4:19 pm
July 25, 2017 at 3:16 pm
July 25, 2017 at 9:29 am
Viewing 15 posts - 14,641 through 14,655 (of 59,063 total)