Viewing 15 posts - 4,591 through 4,605 (of 22,211 total)
Henrico Bekker (7/13/2016)
Sorry to resurrect this thread, has 2014 BPA been released? Can't find it anywhere.
No. I don't think you they are maintaining that code any more.
July 13, 2016 at 11:19 am
durga.palepu (7/12/2016)
text datatype is supported in SQL 2012 but will be deprecated in future versions.alternative is to use varchar(max) and if you need multilingual support use nvarchar(max) datatype.
Thanks,
Durga
Yeah, trace is...
July 13, 2016 at 7:45 am
Oh, and as far as the wait stats go, that's cumulative for the server. Looking at it in isolation for a problem of this type doesn't tell us anything at...
July 13, 2016 at 6:27 am
paolobianchi (7/13/2016)
(can i find waiting cause of a single query someway? I can just profile becuse i don't have sufficient permission on server to use extended events... 🙁
Thank you!
Paolo
You can...
July 13, 2016 at 6:26 am
To do what you're looking for requires you to change your code to dynamic T-SQL. However, that also exposes you to SQL Injection attacks, so you'll have to write additional...
July 13, 2016 at 5:34 am
paolobianchi (7/13/2016)
they seems identic to me, but ok, take the actual execution plan 🙂
Same plan, but a little bit of added detail. It's the estimate vs. actual that gets interesting...
July 13, 2016 at 5:31 am
For such simple queries, there's not much in the way of tuning opportunities. The SELECT query is TRIVIAL, which means that there is only one possible execution plan. The one...
July 13, 2016 at 5:27 am
For licensing questions, always go to Microsoft. You don't want to put your company at risk because of something that some person on the internet said.
July 13, 2016 at 5:17 am
I wouldn't use TEXT. It's on the deprecation list.
Here are the data types in the SQL Server documentation. You're describing what is CHAR, VARCHAR or TEXT, only you shouldn't...
July 12, 2016 at 3:34 pm
What are your wait statistics? What is the server actually running slow because of? That's one of the most important things to know about.
July 12, 2016 at 11:32 am
GilaMonster (7/12/2016)
Database admin(DBA) (7/11/2016)
It seems like its not related to CPU issue nor memory issue.i beileve its related to SQL Latches and their indicate like performance issue.
Performance tuning shouldn't...
July 12, 2016 at 7:42 am
VastSQL (7/11/2016)
Grant Fritchey (7/11/2016)
This indicator is just an indicator of load. If it goes up or down compared to the baseline (which I get that you're...
July 11, 2016 at 6:31 am
As Gail says, they are per instance. You can create a script that will allow you to create the same trace on all your instances if you so desire. In...
July 11, 2016 at 5:50 am
I'll say the same thing I always say about licensing questions on SQL Server. Go straight to the people who are going to audit you, Microsoft. They determine what's in...
July 11, 2016 at 5:48 am
johnwalker10 (7/9/2016)
Sometimes this error message occurs due to network traffic on the server. In such situation you need to change the Time
The time? Changing the date & time on the...
July 11, 2016 at 5:47 am
Viewing 15 posts - 4,591 through 4,605 (of 22,211 total)