In a SQL Server 2012 version 11.0.5058 I've a query like this
SELECT TOP 30
row_number() OVER (ORDER BY SequentialNumber ASC) AS [row_number],
o.Oid, StopAzioni
FROM
tmpTestPerf O
INNER JOIN
Stati s on O.Stato = s.Oid
WHERE
StopAzioni = 0
When I use ORDER BY Sequenti...
Do you really have a table with more than 64 indexes? With 64 foreign keys to other tables? Can you explain, with an example, what does the "one table represents a datatype, which might be used by 100 other entities" mean? — ypercube3 mins ago
Hello, I'm having a problem, when I use SSMS 2012 to select 1 record in a table with 10 million records from my computer outside the server network that kill the whole server, instead if I run the query in a remote desktop in a computer inside the server network, it runs good without any problem. Do you know why this happen?
@EmilioGort Would you be able to connect to the server remotely, then run the query from your computer across the Internet and observe the server's behaviour in the remote session?
After doing a data migration from an old system, I came across a situation where there are records without dates.
The example I give above is the situation I have. I have nowhere to get the data from those NULL. So what is logically set to:
Get the Minor date within that range (00013 or 0...
Is it really valid syntax to to UPDATE MyTable T I thought you could only alias in the FROM (and yes, it's rhetorical as I'm writing up a demo to answer my own question)
@Lamak well they only want to restore when disaster happens. But they need it to be fully automatic. I guess they don't understand what DBAs and consultants get paid for.
I have a mssql db of having min 39gb of finger print data , now required to find out the duplicates within it , each finger print record has a minimal (reduced here) structure as follows
[EMP ID] [finger print IMAGE] [finger print TEMPLATE (ISO)]
I’m using (1 to 1 Comparison ) a C# ...
@billinkc I presume the computational complexity of the algorithm is a given, so the only option would be to apply brute force, in which case Hadoop might be an option.
I need to add a computed column to a table.
The value is computed from columns in other tables, so I need to use a user-defined function.
The issue is that I need to execute dynamic SQL inside my function, but this is not allowed.
What are my options in this scenario? Thank you.
Went to a concert at First Ave last night and was very very annoyed to see that the Machine that I have for 3 years held the Galaga high score was out of service.
@Marian The stuff about setting CPU affinity (to up to 256 processors?) for SQL Server, and enabling soft NUMA, with no explanation as to why you would want to do this, does seem crazy.
I suspect it's not a coincidence that SAP is involved. SAP seems to have weird database tuning advice in general.
In a SQL Server 2012 version 11.0.5058 I've a query like this
SELECT TOP 30
row_number() OVER (ORDER BY SequentialNumber ASC) AS [row_number],
o.Oid, StopAzioni
FROM
tmpTestPerf O
INNER JOIN
Stati s on O.Stato = s.Oid
WHERE
StopAzioni = 0
When I use ORDER BY Sequenti...
After doing a data migration from an old system, I came across a situation where there are records without dates.
The example I give above is the situation I have. I have nowhere to get the data from those NULL. So what is logically set to:
Get the Minor date within that range (00013 or 0...
I have a mssql db of having min 39gb of finger print data , now required to find out the duplicates within it , each finger print record has a minimal (reduced here) structure as follows
[EMP ID] [finger print IMAGE] [finger print TEMPLATE (ISO)]
I’m using (1 to 1 Comparison ) a C# ...
I need to add a computed column to a table.
The value is computed from columns in other tables, so I need to use a user-defined function.
The issue is that I need to execute dynamic SQL inside my function, but this is not allowed.
What are my options in this scenario? Thank you.
