Viewing 15 posts - 4,231 through 4,245 (of 49,571 total)
It's lack of parameter sniffing. The optimiser can't sniff the values of variables and hence assumes a default row count estimation.
Usually fixed by either OPTION(Recompile) or OPTION(Optimize for ...)
November 20, 2015 at 12:31 pm
rameelster (11/20/2015)
Production DB server is showing 98 percent always.How to bring it down
Why? What good is free memory that's not being used?
Surely you want all the resources in the...
November 20, 2015 at 12:28 pm
ScottPletcher (11/20/2015)
Eventually the timeouts built into SQL to prevent tasks from waiting forever would kick in and SQL would just cancel your request to read the table.
Not unless the client...
November 20, 2015 at 12:23 pm
Start by revoking unnecessary sysadmin permissions. If someone's got sysadmin, you can't stop them from doing something to your DB. You can slow them down (eg DDL triggers), nothing more.
November 19, 2015 at 1:14 pm
Not asking for the output of CheckDB. I'm asking if you know or checked how many rows were discarded when you ran DBCC CHECKTABLE (PreAudTranHdr, REPAIR_ALLOW_DATA_LOSS), because it will have...
November 19, 2015 at 12:42 pm
Depends on whether you want the indexes partition-aligned or not. There are valid reasons to do both
November 19, 2015 at 12:37 pm
KlaasTimmermans (11/19/2015)
( even with mdf youwillmay be able to attach )
May, not will. Without the ldf, the database might attach. Or might not. It's not guaranteed.
November 19, 2015 at 12:34 pm
Phil Parkin (11/19/2015)
The caveat to this is that if someone created the DB and specified upon creation that the file extensions should be .sql instead of mdf/ndf/ldf
Shudder.
I once created...
November 19, 2015 at 7:04 am
It's just the default extension for a text file containing T-SQL code. A .sql file isn't a database.
November 19, 2015 at 5:45 am
No good reason. Probably it started as
select A1.ID,A1.Quantity,(B1.Value/A1.Quantity) as ValuePerUnit
from A1, B1
where A1.identity = B1.identity
and then changed to use a JOIN and the where clause never removed.
November 19, 2015 at 4:06 am
You can't create an index on a blob column, that's varchar(max), nvarchar(max), varbinary(max), XML or the old TEXT, NTEXT, IMAGE
If you want to enforce uniqueness across the two columns, the...
November 19, 2015 at 4:05 am
Perry Whittle (11/18/2015)
or lots here on Redgates own site 😉
Simple Talk's also run by Red Gate.
November 18, 2015 at 12:15 pm
You mean in Explorer? Or programatically?
November 18, 2015 at 12:12 pm
Viewing 15 posts - 4,231 through 4,245 (of 49,571 total)