Viewing 15 posts - 436 through 450 (of 18,926 total)
Chrissy321 (12/13/2011)
I think MIRROR TO is only for Enterprise Edition. I am on Standard. A lightweight vb script seems like an option I'll explore that.
Cancel that.
December 13, 2011 at 11:11 am
SQL Kiwi (12/13/2011)
Ninja's_RGR'us (12/13/2011)
How many minutes of processing does that save you on your prod servers? 😉
None, but I have a tidy mind. Can we get back to...
December 13, 2011 at 11:10 am
Does this return anything?
SELECT r.[session_id]
, c.[client_net_address]
, s.[host_name]
, c.[connect_time]
, [request_start_time] = s.[last_request_start_time]
, [current_time] = CURRENT_TIMESTAMP
, r.[percent_complete]
, ...
December 13, 2011 at 11:05 am
SQL Kiwi (12/13/2011)
Ninja's_RGR'us (12/13/2011)
Not very large and count_big are somewhat mutually exclusive in my mind :-D.
I use it because COUNT introduces a pointless conversion to integer. Saves me a...
December 13, 2011 at 10:56 am
DB in simple mode?
Taking regular log backups?
December 13, 2011 at 10:55 am
Err, you don't update master DB you alter tempdb location.
Assuming this is a test server just come back here to debug. This is a relatively low risk action.
December 13, 2011 at 10:54 am
Not very large and count_big are somewhat mutually exclusive in my mind :-D.
December 13, 2011 at 10:53 am
Edit - missed something.
Edit 2 Wow Can't read today!
SELECT TOP ( 10 ) PERCENT
SUM(qty) AS SumQty
, productid
FROM
Sales.OrderDetails
GROUP BY
...
December 13, 2011 at 10:22 am
This is a much better way of doing that =>
DECLARE @StartDate DATETIME
SET @StartDate = DATEADD(D , 0 , DATEDIFF(D , 0 , GETDATE()))
SELECT
'Comment this out'
...
December 13, 2011 at 10:07 am
Dev (12/13/2011)
Ninja's_RGR'us (12/13/2011)
chetanr.jain (12/13/2011)
sp_whoisactive == ?Does not seems to be familiar procedure.
can anybody post the code for this procedure.
Damn google, always down when you need it! ...
December 13, 2011 at 9:14 am
chetanr.jain (12/13/2011)
sp_whoisactive == ?Does not seems to be familiar procedure.
can anybody post the code for this procedure.
Damn google, always down when you need it! 😉
December 13, 2011 at 9:07 am
Before you waste any more time on this issue (which you can't really avoid).
December 13, 2011 at 7:23 am
Reformatted for CS servers.
Also reformatted with my tools.
SELECT
object_schema
, object_name
, CASE WHEN dataobjecttype = 'P' THEN '@'
...
December 13, 2011 at 6:12 am
Or debug your excel code and see what it enters 1 null for everything row.
Not a bug with SS in any way.
December 13, 2011 at 5:41 am
ns22boss (12/13/2011)
Hi,I dont want that to be present in my DB... Is there any way to avoid that Default Row in DB ??
Thanks
Delete where <your id field> IS NULL
If you...
December 13, 2011 at 5:37 am
Viewing 15 posts - 436 through 450 (of 18,926 total)