Viewing 15 posts - 421 through 435 (of 6,036 total)
It’s hard to give a solution for an unknown task.
The overall approach could change substationslly, depending on what you’re trying to achieve.
Are you trying to create tables on remote servers?
May 15, 2019 at 3:39 am
Hi DBAs, I have a performance issue with one hierarchy processing related query. Here is the scenario: I have following two temp tables with sample data: #temp_Mainhier (It is...
May 15, 2019 at 2:06 am
Where are linked servers?
No linked server is indicated in your script.
May 15, 2019 at 1:19 am
My current the approach is using the IF EXIST(Select... , but, even with a properly formed index is still too slow. I am going to try the Upsert suggestion...
May 15, 2019 at 1:14 am
Verifying backups is another story. Well, it's kinda connected, but still another one.
It's possible to do robust verification of SAN backups as well as SQL backups.
So, I would not put...
May 12, 2019 at 8:20 am
SAN backup is a backup of a server with everything on it.
SQL backup is a backup of a specific database.
SAN backup is a blunt and, I'd say' dumb, tool.
If you...
May 11, 2019 at 1:39 pm
I don't know what's the internet and how to unbreak it, but I could participate mostly on the go, from my Apple mobile devices.
previous upgrade made it very difficult to...
May 6, 2019 at 9:24 pm
Look at the progress we've got in SQL over the years!
what used to be 13 years ago a short inline formula using system functions and integer arithmetic is now implemented...
May 3, 2019 at 2:30 am
How should the following sequence be presented?
30 December 2019 Business
31 December 2019 Holiday
1 January 2019 Holiday
2 January 2019 Business
April 15, 2019 at 6:57 am
Can the actual PARCEL_AREA value possibly have any decimal digits?
What's the idea behind choosing the data type decimal(18,5) for storing its value?
Shouldn't it be some CHAR(6), or at least INT...
April 15, 2019 at 6:32 am
Are you sure users will use only latin letters for their passwords?
Someone with the last name "Shilovich" must be well aware of other alphabets and code pages.
April 15, 2019 at 4:56 am
You may deploy a named instance of SQL Server on a virtual machine with only one (or how many they need) database required for the application.
Make sure the sysadmin account...
April 15, 2019 at 4:47 am
Here is the shorter version, but still better:
create table #Location
(
ShortCode varchar(4)
)
insert into #Location(ShortCode) values('HC')
insert into #Location(ShortCode) values('CH')
insert into #Location(ShortCode)...
March 14, 2019 at 4:34 am
Modify this statement:
UPDATE dS
ET price = t.price
FROM product_details d
JOIN (SELECT *FROM #tmp AS T1WHERE IdentityID BETWEEN @StartID and @EndID) t ON d.id = t.i
By adding
WHERE d.price t.price or...
January 24, 2019 at 7:26 pm
How long the jobs take if there is no deadlock?
January 24, 2019 at 7:16 pm
Viewing 15 posts - 421 through 435 (of 6,036 total)