Viewing 15 posts - 1,111 through 1,125 (of 1,219 total)
To little information given to say anything particularly useful. The fact that Service Broker is involved is not a very important piece of information. The BROKER wait types you see...
July 19, 2013 at 4:12 pm
I reviewed the thread, and all I can make out is that your application produces an error when you try to connect. This does not have to be corruption, it...
July 19, 2013 at 4:09 pm
Tobar (7/19/2013)
I don't think I have ever seen any add-ons for SSMS, but maybe I was just not looking.
A lot of people I know swears by http://www.ssmstoolspack.com/%5B/url%5D by SQL Server...
July 19, 2013 at 3:55 pm
There is a "product guide" which you can download, which gives some more information:
Query-processing enhancements
New cardinality estimator
The cardinality estimator improves the querying process and offers the following benefits:
Consistent, predictable query...
July 19, 2013 at 3:50 pm
To be able to troubleshoot something, I need full information, yes. Here I was wondering whether the only the JUL2013 was indexed - that certainly asks for trouble. And I...
July 19, 2013 at 3:43 pm
TheSQLGuru (7/18/2013)
Hey Erland!! What are you doing here - are you lost?
Yes, I lost an NNTP bridge to the MSDN forums. I figured that if I have to answer...
July 19, 2013 at 2:55 pm
ericjorg (7/18/2013)
1) What do you mean by "Sign the module?" I looked for a way to sign the stored procedure, but couldn't find a way to do it.
ADD...
July 19, 2013 at 1:59 am
Fraggle-805517 (2013-07-18)
Is there a way to disable the user or unmap it from the login?
REVOKE CONNECT TO thisuser
July 19, 2013 at 1:57 am
I forgot: Change SET ANSI_NULLS OFF to ANSI_NULLS ON. ANSI_NULLS OFF is a legacy setting, and there are features in SQL Server that are unavailable when this setting is OFF.
July 18, 2013 at 4:29 pm
As Sean says, there is not much we can do with the query alone.
However, this:
and DATEDIFF(d, @SDate, a.dDateCreated) >= 0
and DATEDIFF(d, @EDate, a.dDateCreated) <= 0
is better written as
and...
July 18, 2013 at 4:26 pm
SSMS will size the columns of the width for the data that is displayed on the first page in the grid. To expand the size for the rows you are...
July 18, 2013 at 4:20 pm
In difference to Kevin, I think that that there is some hope that we may be able to help you in this forum, and save you the cost from hiring...
July 18, 2013 at 4:17 pm
I'm not sure that I know what Grant is talking about. There some changes to the optmizer, as described in Books Online:
Query plans
SQL Server 2014 includes substantial improvements to the...
July 18, 2013 at 2:42 am
DECLARE @oracledate varchar(50) = '25-JUN-13 12.01.15.096000000 AM'
select try_convert(datetime2, substring(@oracledate, 1, 12) + ':' +
...
July 17, 2013 at 4:31 pm
haiao2000 (2013-07-17)
July 17, 2013 at 4:10 pm
Viewing 15 posts - 1,111 through 1,125 (of 1,219 total)