Viewing 15 posts - 3,256 through 3,270 (of 49,552 total)
Table definitions (as CREATE TABLE statements) and sample data (as INSERT statements) please
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 13, 2016 at 4:35 am
Are you seeing any errors in the error log?
Does the job succeed or fail? If fail, with what messages?
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 13, 2016 at 4:01 am
Thread continues http://www.sqlservercentral.com/Forums/Topic1777329-3411-1.aspx
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 13, 2016 at 3:48 am
Jason Tontz (4/12/2016)
Which is better?:
The one that returns the correct results.
IN, along with EXISTS are used when you want to see whether there's a matching row/matching values in the subquery....
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 13, 2016 at 3:16 am
SQL doesn't use the page file. Windows may swap SQL's memory out to the page file is the OS is under memory pressure, but SQL doesn't use it directly.
What counter/monitor...
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 13, 2016 at 3:00 am
Why write your own index maintenance script when there are so many good ones out there?
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 13, 2016 at 2:57 am
himanshu.sinha (4/12/2016)
Question is : Since I am having isolation level as "Read committed" , what is downside of using the NO LOCK with the SELECT ?
In short. Incorrect...
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 13, 2016 at 2:56 am
cad.delworth (4/12/2016)
I guess my brain is just 100% allergic to putting a comma between two table names in a FROM clause. >sigh<
Then take any such occurrence and replace the ,...
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 12, 2016 at 8:30 am
Jeff Moden (4/12/2016)
John Mitchell-245523 (4/12/2016)
...
FROM TableA, TableB
...
FROM TableA CROSS JOIN TableB
... as are these two:
...
FROM TableA, TableB
WHERE TableA.ID = TableB.ID
...
FROM TableA...
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 12, 2016 at 8:02 am
ttdeveloper (4/12/2016)
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 12, 2016 at 7:59 am
J Good (4/12/2016)
SELECT TOP 1 @@servername AS Servername
,[min server memory (MB)] = (select value from sys.configurations where name = 'min server memory (MB)')
,[max server memory (MB)]...
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 12, 2016 at 7:04 am
Start by throwing the cursor away. Triggers should be written in a set-based manor to handle any number of rows in inserted/deleted, not iterate through them. Cursors should be avoided...
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 12, 2016 at 5:22 am
Shouldn't be the case. Compat mode is an instruction to the query processor as to how to treat some T-SQL constructs. It doesn't change the format of the data file,...
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 12, 2016 at 5:11 am
I'm really not fond of OS upgrades, plus the hardware's probably ancient and in need of replacing.
Besides:
https://technet.microsoft.com/en-us/library/dd979563%28v=ws.10%29.aspx
Cross-architecture in-place upgrades (for example, x86 to x64) are not supported.
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 12, 2016 at 4:07 am
Could you be a little more specific as to the scenario and problem?
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, 2016 at 9:32 am
Viewing 15 posts - 3,256 through 3,270 (of 49,552 total)