Viewing 15 posts - 5,341 through 5,355 (of 49,552 total)
Possibly group policy. Maybe chat with the domain admin?
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
July 13, 2015 at 7:27 am
sgmunson (7/13/2015)
(P.S. you needed a TOP (100) PERCENT added to allow your ORDER BY clause)
The order by should be removed, or moved to the query which selects from 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
July 13, 2015 at 7:26 am
WayneS (7/13/2015)
What's your next step?
Bask in the glory.
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
July 13, 2015 at 7:03 am
Irrelevant here. SQL's running as an NT Service login. Those don't have passwords that can expire and you never need to reset them.
What does the error log say when you...
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
July 13, 2015 at 7:01 am
Brandie Tarvin (7/13/2015)
GilaMonster (7/13/2015)
Yes, yes, yes, yes!!!!!!!!Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony
YAY!
What is the degree in?
M.Sc (Computer...
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
July 13, 2015 at 4:55 am
It's really not hard, it's two tables with am outer join. Read the article I referenced, create the numbers table, left join between the numbers table and your data table.
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
July 13, 2015 at 3:56 am
You need a numbers table - https://www.simple-talk.com/sql/database-administration/creative-solutions-by-using-a-number-table/, then it's a simple matter of a left join between the numbers table and the table with your data
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
July 13, 2015 at 3:47 am
Yes, yes, yes, yes!!!!!!!!
Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony
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
July 13, 2015 at 3:24 am
giri10488 (7/13/2015)
can sql server free some memory to os & when,how?
Only when the OS is under memory pressure or someone reduces the max server memory setting.
To be clear, SQL using...
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
July 13, 2015 at 2:41 am
CASE is an expression, it returns a value. You can use it in place of a column, not in place of a predicate
select empid,empName,deptName from employee em
inner department dm on...
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
July 13, 2015 at 2:39 am
giri10488 (7/13/2015)
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
July 13, 2015 at 2:32 am
No, he's working off recommendations probably 15 years old. SQL doesn't use the swap file, you need it large enough to be able to hold a Windows minidump and that'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
July 10, 2015 at 12:27 pm
Can't see your picture.
No, probably not. There are a lot of reasons why you might see more lock acquired than released. Lock conversions (U to X) or escalations (row 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
July 10, 2015 at 12:23 pm
Why are you planning to partition? What's the purpose? What's the goal?
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
July 10, 2015 at 12:15 pm
For what it's worth, I don't think I've ever seen a SQL performance problem due to the network. I've seen general slow response from a cloud server, but that's general...
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
July 10, 2015 at 4:45 am
Viewing 15 posts - 5,341 through 5,355 (of 49,552 total)