Viewing 15 posts - 9,331 through 9,345 (of 49,552 total)
Regional settings on the server are probably different.
Datetime and smalldatetime don't have intrinsic formats. They're stored kinda as floating point values.
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
April 11, 2014 at 10:09 am
Why are you even running fibre mode? It's not a generally recommended setting, very advanced, It disabled or breaks so many other things.
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
April 11, 2014 at 9:55 am
charipg (4/11/2014)
actually we need to resolve the issue without reconfigure the replication .
Did you try the steps that the documentation stated?
Step 2: Execute sp_restoredbreplication (Transact-SQL). If this stored procedure...
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
April 11, 2014 at 4:55 am
What didn't work out? What did the referenced Books Online page say?
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
April 11, 2014 at 4:20 am
charipg (4/11/2014)
See the topic MSSQL_ENG003165 in SQL Server Books Online.
What did Books online say on the referenced page?
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
April 11, 2014 at 4:05 am
What do you mean "Everything under that gets rejected"? What is the exact behaviour you're seeing? What errors are you getting?
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
April 11, 2014 at 2:27 am
Huh???
If you need Table A, you access table A. If you need table E, then access table E. Why would you ever access tables B, C and D if all...
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
April 11, 2014 at 2:26 am
Cody K (4/10/2014)
How does it get coordinated over a group of programmers?
You put it in the coding standard, along with all your other good, required coding practices and require people...
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
April 11, 2014 at 1:30 am
Pretty much.
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
April 10, 2014 at 3:44 pm
Not actually a big mistake.
In the where clause, the Daily_car_detail table is joined to the deleted table, but the inserted table isn't joined, so you get a cross join with...
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
April 10, 2014 at 3:33 pm
First thing: Views are not a performance tuning technique. This is because SQL in-lines the views during parsing phase and so by the time the optimiser gets the query, there's...
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
April 10, 2014 at 1:50 pm
a4apple (4/10/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
April 10, 2014 at 12:56 pm
I will also suggest, if you've never written an article for publication before, ask someone to look over it before you submit it. Take that person's comments and review/rewrite as...
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
April 10, 2014 at 12:52 pm
praneethydba (4/10/2014)
and he reduced the memory CAP to 10 GB, and no issues till now....
Why? Why would you want more than half of the memory on the server to...
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
April 10, 2014 at 12:12 pm
It depends. It's definitely not something I'd set everywhere. It doesn't look at the time queries take, it looks at their cost and that's an estimate. It doesn't stop a...
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
April 10, 2014 at 11:48 am
Viewing 15 posts - 9,331 through 9,345 (of 49,552 total)