Viewing 15 posts - 316 through 330 (of 1,583 total)
Joy Smith San (3/15/2014)
A rollback takes as long or longer than the operation had until the point it was cancelled. You wait, because there's nothing else you can do.
Gile,
Suppose an...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 15, 2014 at 11:07 am
you will need to run a query to find "your" blocked spid and kill that if you want to use the current SSMS application you have open (you will need...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 15, 2014 at 6:57 am
You just have to wait for the rollback to complete (and yes it may take a very long time for such a large table). What do you mean the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 15, 2014 at 6:42 am
the script below will help - you can parse through the "PackageData" column to see what each connection string is pointed to with ChildFolders
as
(
select PARENT.parentfolderid, PARENT.folderid,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 14, 2014 at 11:32 am
Is this database acting as a publisher? Or do you have CDC enabled? What does the log_wait_reuse_desc say?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 14, 2014 at 11:11 am
You should never opt to use RECOMPILE over looking to see if you need an index (and creating it if it is needed). That being said, you don't want...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 14, 2014 at 6:15 am
Is there any chance there was index, or statistics maintenance going on during this time?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 13, 2014 at 8:27 pm
Ouch, very sorry about that, Ville-Pekka Vahteala is correct, these service do NOT need to be enabled.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 13, 2014 at 7:12 pm
Glad you got it figured out without resorting to using the hints 😉
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 13, 2014 at 7:08 pm
You mean that the input parameter contains a string like: 'INPS45,INPS46,XYZK45'?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 13, 2014 at 9:56 am
Thanks for clarifying that Gail, I see the difference!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 13, 2014 at 8:37 am
To aid, you can also use:
DBCC FREEPROCCACHE(plan_handle) - this will only remove the plan for the specific thing you're running and will not flush the entire cache.
Or, if it's a...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 13, 2014 at 8:25 am
You could also create a variable in your package, set it to the rowcount of the table, then add a precedence constraint on your connection to the send mail task...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 13, 2014 at 8:17 am
Give this a try:SELECT City, cust_name [Customer], SUM(sales) [Sales] FROM cust_details
WHERE city = 'Tamilnadu'
GROUP BY GROUPING SETS ((city, cust_name), ())
SELECT cust_name [Customer], SUM(sales) [Sales] FROM cust_details
WHERE city = 'Tamilnadu'
GROUP...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 13, 2014 at 8:14 am
selvakumar.sms (3/13/2014)
here my small doubt i need IIS service in Server or i need to enable SMTP service in server ?
IIS and SMTP services are not...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 13, 2014 at 6:01 am
Viewing 15 posts - 316 through 330 (of 1,583 total)