Viewing 15 posts - 2,371 through 2,385 (of 5,841 total)
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
For those using ROW_NUMBER, if you want users having 2 OR MORE roles, shouldn't the filter be rownum >= 2 instead of just rownum = 2?
September 10, 2013 at 11:22 am
Since you are on SQL 2012, new Windowing Functionality is available too. Here is a solution based on that. Note you may want to add in columns and/or...
September 9, 2013 at 8:03 am
Viewing 15 posts - 2,371 through 2,385 (of 5,841 total)