Viewing 15 posts - 7,201 through 7,215 (of 49,571 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...
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...
November 26, 2014 at 1:31 am
From the article:
Apply Cumulative Update #2 (12.0.2370) from KB #2967546.
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...
November 26, 2014 at 1:27 am
Edit -> Intellisense -> Refresh local cache (Ctrl-Shift-R)
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...
November 25, 2014 at 7:01 am
To be clear, this is a client-side error. It's Management Studio that's running out of memory, not SQL Server.
November 25, 2014 at 6:10 am
zedtec (11/25/2014)
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.
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/
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....
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...
November 24, 2014 at 7:50 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?
November 24, 2014 at 7:25 am
Viewing 15 posts - 7,201 through 7,215 (of 49,571 total)