Viewing 15 posts - 8,461 through 8,475 (of 39,804 total)
TimCarrett (3/4/2016)
Ok so don't use windows calculator to try to calculate this. I can now see my mistake.Good question, poor calculator skills.
I think I did that a few times writing...
March 4, 2016 at 9:03 am
Do some testing. I have no idea what your table is, but I did this:
CREATE TABLE News
(NewID INT IDENTITY(1,1)
, NewsTitle VARCHAR(250)
, NewsAbstract VARCHAR(6000)
, NewsDate DATETIME2
)
GO
I loaded 50,000 random rows in...
March 4, 2016 at 8:55 am
I tend to agree with Jeff on performance. If something is a one-off, maybe you sacrifice performance for getting things done, but if it repeats, don't treat the process lightly.
I've...
March 4, 2016 at 8:42 am
Perhaps you can share some DDL and data to understand what you mean.
March 4, 2016 at 8:39 am
First things, I wouldn't change the IP here. I'd actually change to an FQDN, and use that in the future. There have been reports of issues here, so if you...
March 4, 2016 at 8:26 am
I'm confused. Service accounts are Windows accounts only. If you're speaking of logins in SQL Server, then follow the advice above with regards to password policy
March 4, 2016 at 8:09 am
Grumpy DBA (3/3/2016)
Booooo to you and Ray K!!!! The Evil Empire will crumble to the ground!!!
Will? Isn't it?
It has before. After the 70s, quite a drought.
But they will come...
March 3, 2016 at 12:54 pm
This is a Windows level setting, and usually there is a limit. I think it's 3, but it might depend on your particular OS version and AD settings.
I might set...
March 3, 2016 at 11:33 am
Luis Cazares (3/3/2016)
Use a CTE or derived table to generate the LEAD and LAG before filtering.
+1
March 3, 2016 at 11:31 am
It is a regular battle. One reason that RG moved to outsource the sending. I used to do this, and it was a day a week to work through spam...
March 3, 2016 at 9:26 am
robert.sterbal 56890 (3/3/2016)
Free and Open source software allow you to take action on a flaw without being dependent on the vendor.
Absolutely true as a hypothesis.
Not very true in reality. Most...
March 3, 2016 at 9:23 am
Yankees for me, and Rockies since I live in Denver.
Too busy with kid stuff this year. Middle kid graduates HS and the younger one is busier with volleyball. Add in...
March 3, 2016 at 9:11 am
All of those are valid statements in my SQL 2012 and SQL 2014 instances. Didn't try 2016, but I'm sure it's the same.
You have different control of tempdb. I believe...
March 3, 2016 at 9:10 am
Have to say I'm less excited this year. Between not playing (time, shoulder), and the Rockies not looking good, I'm a little down.
🙁
March 3, 2016 at 8:29 am
Viewing 15 posts - 8,461 through 8,475 (of 39,804 total)