Viewing 15 posts - 7,201 through 7,215 (of 49,552 total)
And digging a bit further (cause it's more fun than doing performance reviews)
http://www.sqlserverpeoples.com/SearchFaq.aspx?source=home&fpi=sql&fl=bas
Truncate Truncate command is used to remove all rows of the column. The removed records are not recorded...
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
November 26, 2014 at 2:08 am
Stuart Davies (11/26/2014)
rahul.neekhra 81176 (11/26/2014)
Hi,Find the interview questions and answers here http://www.sqlserverpeoples.com/Examples.aspx
Not sure about that being useful in the real world, a comment from a script (first one I looked...
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
November 26, 2014 at 1:31 am
From the article:
Apply Cumulative Update #2 (12.0.2370) from KB #2967546.
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
November 26, 2014 at 1:29 am
It'll work. It's not ideal. You have all the limitations of the 32-bit SQL Server with regard to memory. You really should be using 64 bit these days (where 'these...
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
November 26, 2014 at 1:27 am
Edit -> Intellisense -> Refresh local cache (Ctrl-Shift-R)
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
November 25, 2014 at 7:20 am
jacksonandrew321 (11/25/2014)
GilaMonster (11/25/2014)
jacksonandrew321 (11/25/2014)
Read more about clustered indexes and non clustered indexes here
Considering that the article is completely wrong about index structure, I'd recommend not reading it.
Indexes are not binary...
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
November 25, 2014 at 7:01 am
Have you tried the FLOOR function?
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
November 25, 2014 at 6:31 am
To be clear, this is a client-side error. It's Management Studio that's running out of memory, not SQL Server.
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
November 25, 2014 at 6:10 am
zedtec (11/25/2014)
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
November 25, 2014 at 5:17 am
jacksonandrew321 (11/25/2014)
Read more about clustered indexes and non clustered indexes here
Considering that the article is completely wrong about index structure, I'd recommend not reading it.
Indexes are not binary trees.
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
November 25, 2014 at 4:27 am
Have a read through this, the section on TempDB should help
https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
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
November 25, 2014 at 4:25 am
Running SQL Profiler against a production server should be a fireable offense. It puts horrible load onto a server, especially if the person hasn't been careful about filtering their trace....
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
November 24, 2014 at 8:31 am
Koen Verbeeck (11/24/2014)
Sean Lange (11/24/2014)
prachisaxena201 (11/24/2014)
SELECT @battery_included = COALESCE(@battery_included + ';', '') + CONVERT(VARCHAR(200),Item)FROM dbo.Split(@battery,';')
help me to understand this query
It looks like you have a delimited string 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
November 24, 2014 at 7:50 am
See the first link in Sean's signature.
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
November 24, 2014 at 7:33 am
You don't, unless you're running 32-bit SQL Server on a 32-bit OS.
What's the background? 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
November 24, 2014 at 7:25 am
Viewing 15 posts - 7,201 through 7,215 (of 49,552 total)