Viewing 15 posts - 4,426 through 4,440 (of 8,761 total)
Ed Wagner (9/29/2015)
Luis Cazares (9/29/2015)
Ed Wagner (9/29/2015)
djj (9/29/2015)
Ed Wagner (9/29/2015)
SQLRNNR (9/28/2015)
DonlSimpson (9/28/2015)
Ed Wagner (9/28/2015)
whereisSQL? (9/28/2015)
djj (9/28/2015)
Ed Wagner (9/28/2015)
anthony.green (9/28/2015)
ZZartin (9/28/2015)
LeafHeap
Cluster
Single
Engaged
Active
Passive
Node
Tree
Family
History
Channel
Triggers
Hair
September 29, 2015 at 9:48 am
aymanahmed88 (9/29/2015)
i need to store list of array in one parameter to complete my query
i try the table value but...
September 29, 2015 at 9:39 am
Grant Fritchey (9/29/2015)
September 29, 2015 at 4:38 am
rwitt 95744 (9/28/2015)
I'm curious what are the most important/relevant stats, query plan aspects, etc., that you look at, when trying to determine if one T-SQL coding approach is more...
September 28, 2015 at 11:33 pm
serg-52 (9/28/2015)
To optimize a bit further why declare namespace which is never used in the query
;WITH XMLNAMESPACES (DEFAULT 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/shareddatasetdefinition')
SELECT
D.field1.value('(SharedDataSet/DataSet/Query/CommandText/text())[1]','VARCHAR(50)') AS CommandText
FROM #demo D;
Since it...
September 28, 2015 at 1:10 pm
Quick thought, the posted solution works but it imposes quite a lot of work which can be avaided, here is a more efficient alternative.
😎
USE tempdb;
GO
SET NOCOUNT ON;
IF OBJECT_ID(N'sbo..#demo') IS NOT...
September 28, 2015 at 11:05 am
As pietlinden mentioned, locate the files, make certain that the right permissions are in place for the SQL Server (the credentials the server is running under) to access the files...
September 27, 2015 at 7:51 pm
You might want to carefully select the database and the tables to tune in the General Tab, start with few and add more, even in a different session.
😎
September 27, 2015 at 3:47 am
Quick question, are you trying to analyze everything on a large server in one go?
😎
September 27, 2015 at 2:38 am
ramezani583 21209 (9/27/2015)
What to do when Consuming Workload Fails in Database Engine Tuning Advisor?
The minimum storage space required for the existing physical design structure (PDS ( you have...
September 27, 2015 at 2:05 am
Quick question, what else is running on the server beside the Sql Server?
😎
September 27, 2015 at 12:30 am
robinwilson (9/26/2015)
I have to update the instance name in all stored procedures and functions but cannot seem to find a way to obtain the up to date full contents of...
September 26, 2015 at 8:10 pm
Ed Wagner (9/25/2015)
SQLRNNR (9/25/2015)
Eirikur Eiriksson (9/25/2015)
SQLRNNR (9/25/2015)
Steve Jones - SSC Editor (9/25/2015)
Personally, as I get older, I don't want a cannon. Hard on the wrists and arms.
Just mount it to...
September 26, 2015 at 10:06 am
Kristen-173977 (9/26/2015)
GilaMonster (9/24/2015)
Kristen-173977 (9/23/2015)
GilaMonster (9/23/2015)
September 26, 2015 at 2:58 am
Viewing 15 posts - 4,426 through 4,440 (of 8,761 total)