Viewing 15 posts - 5,311 through 5,325 (of 26,490 total)
kevaburg (5/6/2015)
does anyone have any good resources or links regarding licensing SQL Server 2008 on a VMWare ESXi Server?
The problem is that at the moment we have 20 SQL...
May 6, 2015 at 12:20 pm
New Born DBA (5/6/2015)
So COL_CORE_Audit_Data is a view? Need to see the DDL for the view and the underlying tables and the indexes on the tables.
Index 1:CREATE NONCLUSTERED INDEX [I387_6_1]...
May 6, 2015 at 12:11 pm
New Born DBA (5/6/2015)
Lynn Pettis (5/6/2015)
New Born DBA (5/6/2015)
May 6, 2015 at 11:15 am
New Born DBA (5/6/2015)
May 6, 2015 at 11:08 am
New Born DBA (5/6/2015)
New Born DBA (5/6/2015)
Query returns all data modified in the past 31 days.
Without seeing the indexes defined on the table, not much more can be done.
Index Info.
/******...
May 6, 2015 at 10:38 am
New Born DBA (5/6/2015)
Lynn Pettis (5/6/2015)
Looks like you are storing date information as seconds since midnight 1970-01-01, correct?
Yes, that is correct.
So, what is the where clause attempting to filter?
Sorry, but...
May 6, 2015 at 10:22 am
luissantos (5/5/2015)
I found a code snippet that use the curious following sintax on the creation of View:
CREATE VIEW [dbo].[vw_EvenValues]
AS
SELECT [TestColumn]
FROM [dbo].[TestTable]
WHERE [TestColumn] % 2 = 1
I...
May 6, 2015 at 10:04 am
New Born DBA (5/6/2015)
SELECT...
May 6, 2015 at 9:55 am
ramana3327 (5/6/2015)
To...
May 6, 2015 at 9:52 am
Dan121 (5/5/2015)
Thanks Lynn,I was practicing delete million rows in small batch to prevent log size getting big.
Okay, then you also need to incorporate t-log backups if the database is not...
May 5, 2015 at 11:27 am
jasona.work (5/5/2015)
I'm also surprised that (in my quick Googleing) there aren't more discussions / blog post / articles around the web on applying...
May 5, 2015 at 11:00 am
Dan121 (5/5/2015)
I am trying to delete thru small chunk from [AdventureWork].[Sales].[SalesOrderDetail]. I like to delete 10000 at a time where 'SalesOrderDetailID' > 50000. Another word I like to...
May 5, 2015 at 10:55 am
Perhaps something like this:
declare @MyValue float = 0.2;
select right('000' + ltrim(str(@MyValue,10,2)),6);
May 5, 2015 at 10:48 am
sharonsql2013 (5/4/2015)
declare @ThisDate datetime;
set @ThisDate = GETDATE();
with ThreeWeek as (select rn from (values (0),(1),(2))dt(rn))
select distinct dateadd(wk, datediff(wk, 0, @ThisDate) +...
May 5, 2015 at 8:06 am
Charles Kincaid (5/4/2015)
TheSQLGuru (4/30/2015)
Hmm. Wouldn't adding a meaningful index to a table cause "affected" plans to recompile? Bit tired at the moment so could be confuzzled ... :w00t:
That would be...
May 4, 2015 at 2:59 pm
Viewing 15 posts - 5,311 through 5,325 (of 26,490 total)