Viewing 15 posts - 2,371 through 2,385 (of 5,843 total)
GilaMonster (9/20/2013)
Please post table definition, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
+1
How can we optimize a query without knowing the tables, indexes, views, functions, etc in play?
Data distribution will...
September 20, 2013 at 9:41 am
I too will recommend Kimball.
I will also add that I have been pulled into numerous DW projects as a consultant that were near or complete failures, in an effort to...
September 20, 2013 at 9:38 am
al_nick (9/18/2013)
I'm trying to flatten this table into something like the second table. Any suggestions would be greatly appreciated.
Nick
See the attached table in Excel.
Entity | Attribute ...
September 18, 2013 at 9:13 pm
There are SOOOO many things that come into play with the term "query performance". And which one(s) of those things is MOST important for a GIVEN QUERY EXECUTION can...
September 17, 2013 at 10:18 am
Google is your friend: http://lmgtfy.com/?q=sql+server+column+level+encryption
Oh, and Books Online is a great resource too!
September 14, 2013 at 9:48 am
GilaMonster (9/13/2013)
TheSQLGuru (9/13/2013)
4) The WITH (ROWLOCK) hint could be helpful. See Books Online for info.
Or could make it worse. 15000 rows locked at the row level is above the...
September 14, 2013 at 7:17 am
ekant_alone (9/13/2013)
BEGIN
STEP 1) Archive records into Table A..... (around 15K records)
from TABLE B
STEP 2) Delete some...
September 13, 2013 at 9:27 am
I totally don't understand what the output you expect for this. Please provide the ACTUAL output you expect for your given sample. You may need to set up...
September 13, 2013 at 9:21 am
See if one of these links can help (from SSC.com's own Jeff Moden):
http://www.sqlservercentral.com/articles/94040/
September 12, 2013 at 12:03 pm
HAH - good one Grant!! And Erland is correct about Profiler.
Oh, and I LOVE DBSophic's Qure product!! That thing makes me look like a WIZARD at...
September 11, 2013 at 1:57 pm
sql_novice_2007 (9/11/2013)
Do I need to install the litespeed on the server or is it ok if I install it on my machine and compress the backup file from my machine?
All...
September 11, 2013 at 8:31 am
p.swathi4 (8/19/2013)
Can you suggest me the best autogrowth settings on the tempdb files
In this particular case I would have NO autogrowth. Make your tempdb file(s) consume the ENTIRE 30GB...
September 11, 2013 at 6:59 am
I think .STContains() is the proper function to use.
September 11, 2013 at 6:54 am
Grant Fritchey (9/11/2013)
Erland Sommarskog (9/10/2013)
Grant Fritchey (9/10/2013)
The only way to get run-time information is to capture the plan while executing using SSMS or extended events.
You can also capture them with...
September 11, 2013 at 6:38 am
If you can keep it SIMPLE, then this is something you might pursue. It could improve your sales closure rate by reducing another impediment/hassle. But know that licensing...
September 11, 2013 at 6:32 am
Viewing 15 posts - 2,371 through 2,385 (of 5,843 total)