Viewing 15 posts - 5,746 through 5,760 (of 49,552 total)
Does this do what you want?
SELECT year, monthname, MIN(startdate), MAX(enddate)
FROM [dbo].[mhs_month_week]
GROUP BY year, monthname
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 29, 2015 at 5:49 am
Test and see, with all the OR conditions that last update will have to be a table scan, but without indexes it'd have to be a table scan anyway
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 29, 2015 at 5:32 am
Restore the DB as NORECOVERY, restore the logs as NORECOVERY. It will work, but it's not a DR setup and the secondary database cannot be made readable. It's typically used...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 29, 2015 at 4:13 am
rajeshjaiswalraj (5/29/2015)
Where DBCC or DMV will store. What its working.
DMVs don't store data, they're views into SQL's internal memory structures mostly, or database structures.
DBCC statements are very varied and there's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 29, 2015 at 4:11 am
DELETE Table1 FROM Table1 INNER JOIN Table2 ....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 29, 2015 at 3:03 am
Steven W (5/28/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 29, 2015 at 2:56 am
Steve Jones - SSC Editor (5/28/2015)
Is there just one? If there's a separate one for VS Online, pass it over.
Why? It'll only show clouds.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 29, 2015 at 2:53 am
No, just that the GUI designer doesn't work up-version. Writing out and running the CREATE TABLE statement works fine
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2015 at 4:31 pm
reddysiri517 (5/28/2015)
Good day, please confirm sleeping sessions or stale session in sql server will use CPU.If we kill sleeping sessions,CPU will come down.
No. Sleeping sessions are doing nothing. Since they're...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2015 at 6:18 am
WhiteLotus (5/27/2015)
the result is :
(45108 row(s) affected)
Table 'project_text'. Scan count 1, logical reads 2017, physical reads 0, read-ahead reads 0, lob logical...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2015 at 5:29 am
In that case, it'll be 6 times worst than hopeless.
When it comes to IO throughput, the number of spindles is critical. You have 2. My laptop has that many in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2015 at 1:37 pm
SQLRNNR (5/27/2015)
GilaMonster (5/27/2015)
Looks like I hit a few nerves with Sunday's editorial....Two words...
Ugh
Troll
I'd reply and point out the flaw in his logic (he's got scientific method and scientific consensus the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2015 at 12:33 pm
Bad cardinality estimations perhaps. Can you post the problematic plan?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2015 at 9:30 am
SQL Server doesn't do scale-out (distributed systems) at all well.
What are you trying to do and why?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2015 at 9:28 am
Looks like I hit a few nerves with Sunday's editorial....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2015 at 9:06 am
Viewing 15 posts - 5,746 through 5,760 (of 49,552 total)