Viewing 15 posts - 5,341 through 5,355 (of 49,571 total)
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...
July 13, 2015 at 7:26 am
WayneS (7/13/2015)
What's your next step?
Bask in the glory.
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...
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...
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.
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
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
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...
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...
July 13, 2015 at 2:39 am
giri10488 (7/13/2015)
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...
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...
July 10, 2015 at 12:23 pm
Why are you planning to partition? What's the purpose? What's the goal?
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...
July 10, 2015 at 4:45 am
Viewing 15 posts - 5,341 through 5,355 (of 49,571 total)