Viewing 15 posts - 16 through 30 (of 57 total)
Try parametrized but with a RECOMPILE hint. SQL will then not store a plan but compile a plan optimized for the specified parameters. If then the clustered index is used...
March 15, 2015 at 8:41 am
Can you please attach the actual execution plan? I have seen examples where big tables and small selections render the normal statistics not optimal. Filtered statistics might be an option....
March 14, 2015 at 3:13 pm
Check the protocol in config manager on the server that runs the instance? Is tcp/ip enabled?
Can you ping the server ip? Can you ping the server name? What does nslookup...
March 14, 2015 at 1:12 am
For questions about this code please call Francois at 6345789
Changed code because customer wanted it
March 14, 2015 at 12:04 am
Grant Fritchey (3/9/2015)
ChrisM@Work (3/9/2015)
The optimiser has difficulty with more than seven or eight tables in the FROM list regardless of how they are joined. More than that and you are...
March 9, 2015 at 8:42 am
The two statements are not the same obviously and the outputs are the same because you understand the data. I'm guessing the same ID's existing in all tables. Let outers...
March 9, 2015 at 6:29 am
Do you have the code of the proc? It could be many causes like simultaneous execs of the proc, programming logic or even a variant of the Halloween problem. Is...
March 3, 2015 at 10:15 pm
Perry Whittle (3/3/2015)
Bouke Bruinsma (3/3/2015)
One of our customers asked us why if having multiple datafiles for tempdb is beneficial
can be beneficial, in most cases you may not even need it,...
March 3, 2015 at 6:09 am
What I have done in a similar situation is: create a temp database, select * into temp.temptable, backup the db, restore it on the target instance and use it there...
February 28, 2015 at 1:28 am
I agree also on using Express for light weight purposes. Our company sells some software where SQL Server is just a container for configuration and some data. The workload is...
February 27, 2015 at 3:28 am
GilaMonster (2/23/2015)
Bouke Bruinsma (2/23/2015)
February 23, 2015 at 7:22 am
I wouldn't dare questioning your or Gails remarks. But I could give many examples where a database is in full recovery mode without any backup strategy in place. The log...
February 23, 2015 at 4:34 am
GilaMonster (2/23/2015)
Bouke Bruinsma (2/22/2015)
First of all, make sure you create full backups asap. Big tranlogs are usually a sign of absence of full backups altogether.
Absolutely not. You can have...
February 23, 2015 at 2:00 am
First of all, make sure you create full backups asap. Big tranlogs are usually a sign of absence of full backups altogether. After this, design a backup strategy/BCP.
February 22, 2015 at 12:07 am
I've heard of the reporting service going to sleep. The resolution was to create a scheduled hourly dummy report to keep it awake. I'm afraid I do not have any...
February 18, 2015 at 2:38 pm
Viewing 15 posts - 16 through 30 (of 57 total)