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...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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) + ':' +
...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
July 17, 2013 at 4:31 pm
haiao2000 (2013-07-17)
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
July 17, 2013 at 4:10 pm
Viewing 15 posts - 1,111 through 1,125 (of 1,219 total)