Viewing 15 posts - 1,456 through 1,470 (of 6,036 total)
Can you post the full sets returned by the view for both tables?
The numbers look a bit odd.
Was there any DB shrinking done after the index was created?
And I...
_____________
Code for TallyGenerator
May 3, 2016 at 3:14 pm
Run this:
ALTER INDEX IndexName ON SchemaName.TableName REBUILD
Check the fragmentation stats.
Now let them defragment the HEAP to match the outcome.
_____________
Code for TallyGenerator
May 2, 2016 at 4:52 pm
salliven (5/14/2013)
Can I insert a table without identity reseed?
Exapmle:
CREATE TABLE #table (id int IDENTITY (1,1), col1 int)
INSERT INTO #table DEFAULT VALUES
-- Id = 1
-- If I insert identity values, then...
_____________
Code for TallyGenerator
May 2, 2016 at 4:36 pm
Luis Cazares (5/2/2016)
Sioban Krzywicki (4/29/2016)
Eric M Russell (4/29/2016)
create database [ ];
GO
use...
_____________
Code for TallyGenerator
May 2, 2016 at 4:25 pm
Alan.B (4/29/2016)
This thread has gotten so out of hand.
Well, it was not in good hands from the very beginning.
Is there any demonstrable problem with naming a column "number"?
I think...
_____________
Code for TallyGenerator
May 1, 2016 at 7:25 pm
create table employee_id_mapping
(
employee_id bigint identity(1000000,1),
By using bigint here you're gonna just waste the system resources.
You may have 4 records in your database per every possible SSN number and still stay...
_____________
Code for TallyGenerator
May 1, 2016 at 7:11 pm
j-1064772 (4/29/2016)
Can't help myself.I am calling out every one to push this even further down the road.
Have we reached bottom yet ?
Like some people brackets, I hate Latin alphabet.
It's not...
_____________
Code for TallyGenerator
April 29, 2016 at 3:25 pm
So, what's the problem with this task?
Are you able to google "GROUP BY"?
_____________
Code for TallyGenerator
April 28, 2016 at 11:59 pm
pstanand (4/28/2016)
Hi,So shall I use the below one? Suggest me.
select count(1) from sap_plant
where lastupdate >='20160419'
and lastupdate <'20160428';
Thanks
Regards,
pstanand
Yes.
That would be correct.
If you use paramerters you may wish to user following...
_____________
Code for TallyGenerator
April 28, 2016 at 11:51 pm
There is nothing wrong with objects or columns named Number, Version, Join, etc.
The names don't affect performance or quality of the code anyway.
It's not a bad coding practice either.
The real...
_____________
Code for TallyGenerator
April 28, 2016 at 11:45 pm
jkbarr30 (4/28/2016)
... and what hour they are here
Can you define this please?
Arrived on 8:50 and placed in bed on 9:10 - it's obviously within 1st hour.
But arrived on 8:10 and...
_____________
Code for TallyGenerator
April 28, 2016 at 10:12 pm
Alan.B (4/28/2016)
It's expensive, especially when you look at the number of lob reads, but it's the fastest way to parse XML data using the SQL engine that I'm aware of.
XML...
_____________
Code for TallyGenerator
April 28, 2016 at 9:21 pm
Jeff Moden (4/28/2016)
A lot of people incorrectly consider CROSS APPLY to be RBAR because it behaves like a correlated subquery when single row returns are produced by CROSS APPLY.
It...
_____________
Code for TallyGenerator
April 28, 2016 at 7:14 pm
http://opendata.stackexchange.com/questions/5595/how-should-us-ssn-be-anonimized
Since SSN has only 9 digits, changing hash function will not suffice because attacker can simply apply the function to all 10^9 SSN's and match the result against the database.
Any...
_____________
Code for TallyGenerator
April 28, 2016 at 3:43 pm
Jeff, don't be so sure.
It's MS Windows we're talking about here.
Ever noticed Modified Date earlier than Created Date?
I did. Not once, not twice.
_____________
Code for TallyGenerator
April 28, 2016 at 8:13 am
Viewing 15 posts - 1,456 through 1,470 (of 6,036 total)