Viewing 15 posts - 7,471 through 7,485 (of 49,552 total)
That's damn hard to do in SQL Server. Full text will probably be your best bet, but likely to be hard even with that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 17, 2014 at 7:13 am
No where near enough information.
Can you at least post the query, that may give a starting point. Also, what exactly do you mean by 'wrong result'? Wrong in what way?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 17, 2014 at 7:04 am
Grant's blog was linked in the first reply.
xsevensinzx (10/16/2014)
I would assume they would be on his blog.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 17, 2014 at 5:28 am
Enterprise Manager's not going to be able to connect. I'll be surprised if it can even connect to SQL 2005, much less 2012.
Why are you still using 14 year old...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 17, 2014 at 5:27 am
thespratty (10/16/2014)
UPDATE: the re-indexing has not solved the problem so w're updating the statistics.
Rebuilding an index updates the statistics on that index. There's no need to do it again, unless...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 17, 2014 at 4:56 am
Could you be a bit more specific about what 'they' want?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 17, 2014 at 3:46 am
All posts have always had an edit button.
The part where they're going to a broken site is new, they used to just reload the thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 17, 2014 at 2:46 am
No ORDER BY, no guarantee of order. End of story.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 17, 2014 at 1:30 am
It will enable the new cardinality estimator, which could easily have caused what you see, if the DB had been on compat mode 110. Since it's not, we can eliminate...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2014 at 4:54 pm
Bear in mind that in 2008 Management studio didn't show the spill to TempDB warning. Only from 2012 is that warning shown.
Pull out Profiler, trace for hash and sort spills...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2014 at 4:33 pm
Grant Fritchey (10/16/2014)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2014 at 4:28 pm
If a transaction rolls back, all data modifications done within the transaction are rolled back. Even if they're in different databases.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2014 at 2:58 pm
Darryn_the_Tired (10/16/2014)
Devs have told me they cant change this and its my problem.
Time to get management involved?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2014 at 2:37 pm
Alexander Suprun (10/16/2014)
Create a job which runs every 5 seconds and KILL the processes of specific user(s) where program_name is 'Microsoft SQL Server Management Studio - Query'
And hope they...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2014 at 2:34 pm
Order of columns in a table has no meaning. Just let them go at the end and, if you want them selected out at the beginning write your select statement...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2014 at 2:31 pm
Viewing 15 posts - 7,471 through 7,485 (of 49,552 total)