Viewing 15 posts - 76 through 90 (of 1,583 total)
Has anyone else been through this?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 3, 2015 at 8:46 am
I created a simple scalar function that checks if the folder exists, if it doesn't it creates it - it depends on Jeff Moden's awesome function DelimitedSplit8K, but you can...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 3, 2015 at 8:44 am
sheba.sql (6/3/2015)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 3, 2015 at 8:35 am
That depends on many factors. Not sure "how long" but you can find out how large the snapshot for the tables will be by running something like:
SELECT pubname...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 29, 2015 at 3:50 pm
Out of sheer curiosity; is the backup being done by a 3rd party tool like BackPro, SQSafe, or Lightspeed, etc?
If so, you'll need to kill the actual thread using something...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 29, 2015 at 2:47 pm
I store all my SSIS packages in a local folder on each server (I do not deploy them to the package store)...so I can set them up in the Agent...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 29, 2015 at 2:44 pm
Is your subscriber online? Or are there any processes blocking your distributor sessions?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 29, 2015 at 2:40 pm
Gail, looks like you hit the nail on the head...
In looking through the reporting procedure I did notice a TVF being called (although it really looks harmless and has a...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 5, 2015 at 11:19 am
@Grant - yes it's production (reporting) - and typically I don't do it either but wanted a comparison (its strictly troubleshooting only as I'm not overly familiar with extended events...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 5, 2015 at 10:08 am
This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 7, 2015 at 10:55 pm
I was expecting the raise error function to be thrown if the option was not provided correctly. It only printed the message in the ELSE block.
Can you help me understand...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 7, 2015 at 9:15 pm
I'm not entirely sure this will help but found this article [https://ask.sqlservercentral.com/questions/24486/replication-limit-on-number-of-push-subsciptions.html] - I don't think there's an exact limit as much as there's a threshold with "load"
-Hope it helps!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 7, 2015 at 8:42 pm
I have written a custom script to rebuild index. But if users choose wrong choice, it is supposed to throw a specific error msg which it does not do.
Please help...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 7, 2015 at 8:39 pm
Interesting! I have no experienced this issue.
It could be that you're filling up your files faster than the job is able to pull them out...so it's getting overwritten before...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 26, 2015 at 1:58 pm
How large is the dataset being returned? Not saying the network is to blame but returning data locally will always be faster than retrieving it through a linked server...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 20, 2015 at 2:32 pm
Viewing 15 posts - 76 through 90 (of 1,583 total)