One of the most popular request I have received on this blog is to create one page which list all the SQL Server FAQs. SQL Server technology is very broad as well very deep. This is my humble attempt to list few of the daily used details in one page. Let me know your opinion and suggestion.
Reference : Pinal Dave (https://blog.sqlauthority.com)
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.
36 Comments. Leave new
Hi,
I am having a problem related to INSERT INTO on the following platform:
Microsoft SQL Server 2005 – 9.00.3068.00 (X64) Feb 26 2008 23:02:54 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2).
However, if I use the same query on different platform, shown below, it works fine:
Microsoft SQL Server 2005 – 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2).
My Query:
1) Drop and Create table
2) add index to its columns:
CREATE UNIQUE NONCLUSTERED INDEX [idxGroup4AndInseminationDate] ON [dbo].[tblForInseminationContainingHUKAndNMRDataWithNoDuplicates]
(
[herdBookNumber] ASC,
[breedId] ASC,
[IDType] ASC,
[pedigreeStatus] ASC,
[inseminationServiceDate] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = ON, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
3) Insert data
INSERT INTO [DBO].[tblForInseminationContainingHUKAndNMRDataWithNoDuplicates]
SELECT *
FROM dbo.tblTestForInsemination AS tblA
WHERE tblA.herdBookNumber = ‘E5854/00220’ AND
tblA.breedId = ‘1’ AND
tblA.IDType = ‘2’ AND
tblA.pedigreeStatus = ‘2’ AND
tblA.inseminationServiceDate = ‘2001-03-16 00:00:00.000’
ORDER BY ISNULL(tblA.authenticSire, ‘N’) DESC, tblA.PDResult DESC
In expected result the order by works fine on the second platform but not on the first one, please help.
Thanks
hello Sir,
is there any way to execute a query based on time.
for example: evey 1st day of a month at 11am i want to execute one query. without user intraction
is it possible?
looking from you.
Make use of job which is specifically used for it
Great job buddy..
good sir in sqL Server
Great Job
Good Job…
Really a group of excellent query statement
I think the Microsoft website to download the trial version of their server sucks. I have spent 3 hours trying to find where to click to download the trial version. You get to one page and it’s a dead end every time. I would have thought that for a big IT company they would have hired people to do their web pages that knew what the hell they were doing.
I don’t want to here that it cost $50.00 for the trial because it doesn’t. If you registered as I did do your supposed to be able to download the thing for FREE.
Fantastic!
i want to know ihave find issue on sql server 2000 storedprocedure script excute in a 5 second and on same script excute on sql 2008 take 2 min time plz help
Are they in the same server? Are the table having the same number of records?
Hi all,
I am getting an error while restoring a database from production to test server.
Below is the error:
Operating system error 1130(Not enough server storage is available to process this command.
pls help
It means that your server’s disk does not have enough space to load the database files. Try restoring in another disk with enough space
Thanku very much 4 ur quick reply………backup file size is 140GB…and m having 350 GB of space in that drive…………….?
Hi Vikas, the backup may well be compressed so the size of the MDF and LDF may exceed 350GB when uncompressed