Viewing 15 posts - 556 through 570 (of 3,348 total)
Hi Arbra,
Can you please reate a simplified repro script of what you are trying to do? So just create a simple demo table of two columns or so, add one...
April 2, 2016 at 10:08 am
Lowell (3/31/2016)
--RxClaims.prescriberId LIKE '[a-zA-Z][a-zA-Z]%' --case sensitive collation
I think that would be for a binary collation. For case-sensitive collations, it would be either LIKE '[a-Z][a-Z]%', or LIKE '[A-z][A-z]%' - I can...
April 2, 2016 at 9:55 am
It is (sometimes) okay to shrink a database file or a log file as a one-time operation, if something happened that caused it to grow beyond the normal size.
But I...
April 2, 2016 at 9:43 am
Just be aware that by using this method, the query has to be evaluated twice. Often not a big problem, but if it's a query that takes a lot of...
April 2, 2016 at 9:37 am
It can even be as subtle as accidentally highlihgting part of a script when executing from SSMS. I have not only seen that happen, I have personally done that. (Luckily...
March 31, 2016 at 3:22 pm
doasidont (3/31/2016)
couldn't I use the same 'Where In' clause to qualify (filter) 'Sales'.empID using 'WorkForce' empID? Workforce.empID lists unique ID's. If so,...
March 31, 2016 at 3:17 pm
Luis Cazares (3/31/2016)
SELECT WorkForce.empID,
WorkForce.empName,
WorkForce.zip,
Sales.prodID,
PayTypes.payType,
Products.prodType,
Sum(convert(int,Sales.salesTot)) AS [SumOfsalesTot] --This wass missing a parenthesis
FROM WorkForce
INNER JOIN Sales ON WorkForce.empID...
March 31, 2016 at 3:16 pm
doasidont (3/31/2016)
For tables that are only used to filter the results (only ZipTable in your case,...
March 31, 2016 at 9:34 am
p.shabbir (3/31/2016)
Hi all,Can any one tell me the reason why unique clustered index created by default when we create primary key.
What is the reason?
Thnx in Advnc.
Don't know for sure, you'd...
March 31, 2016 at 9:31 am
Hi Nader,
The plans you post actually have the same plan shape, so they do not explain the performance difference you are seeing.
However, I do see that the estimated rowcounts are...
March 31, 2016 at 9:23 am
Chitown (3/31/2016)
Hugo Kornelis (3/31/2016)
I recommend using this opportunity as a test case to check how long the restore will take. Then compare that with...
March 31, 2016 at 9:07 am
girl_bj (3/30/2016)
I still need to do it manually?getdate till 7 days will be 7 april
Then 8 april till 7 days and so on.
No. Just take the query you use to...
March 31, 2016 at 9:02 am
That might be the solution for you. Or it might be completely wrong. We cannot assess that without knowing more about your data and situation.
As Gail already writes, wo do...
March 31, 2016 at 8:51 am
1200 logical files? That is a lot!
I recommend using this opportunity as a test case to check how long the restore will take. Then compare that with the recovery time...
March 31, 2016 at 8:45 am
A long, long, long time ago, I wrote a chapter for Adam Machanic's book "Expert SQL Server 2005 Development". This chapter was all about working with spatial data, stored as...
March 31, 2016 at 8:40 am
Viewing 15 posts - 556 through 570 (of 3,348 total)