Forum Replies Created
Viewing 15 posts - 4,561 through 4,575 (of 22,227 total)
-
RE: Still Confused about the difference between varchar(max) and varchar(8000)
The main difference is over the use of in-row storage. VARCHAR will always have it, VARCHAR(MAX) will bias towards it, but then move to LOB storage when it needs to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Update statistics after Index Rebuild ?
But only update the column statistics if the automatic statistics updates are not adequate for maintaining them.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Restore 'WITH MOVE' without knowing filenames
I have an article on how to retrieve information [/url]from your backups that could help. You'll just have to convert that information into what you need for the restore as...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Temporal table type functionality for SQL Server 2014
I have done this kind of work before. It's somewhat difficult. Basically you have to arrive at a mechanism to version the data as it goes in. I have some...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
ThomasRushton (8/15/2016)
ChrisM@Work (8/15/2016)
ThomasRushton (8/15/2016)
Grant Fritchey (8/15/2016)
Hey Threadizens!Grant!
Damn. Now I want to watch some Cheers.
Gosh never mind the telly, where's the best curry around here?
It depends. (sorrynotsorry).
Where are you?...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Hey Threadizens!
India was lovely, terrifying, interesting, frustrating and great, all at once. I've taken more selfies with people on this one trip than I had done in my entire life...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: sql server 2016 - Grant Fritchey
That guy is really lazy and has not written a book on 2016.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
ChrisM@Work (8/5/2016)
Grant Fritchey (8/5/2016)
BLOB_EATER (8/5/2016)
I would like to get into the mind-set of speakers out there. Now, as it stands I have zero-interest in presenting/speaking due to a lack of..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
BLOB_EATER (8/5/2016)
what took you so long Grant?:-DNot sure. My son has had one for a year. I've driven it a few times and fell in love. So when the truck...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Joining a cult today
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
jasona.work (8/5/2016)
A thought I had the other day, reading another of Steve's postings on the SQL Saturday thing. Keep in mind, I've been to one, so if this does..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
BLOB_EATER (8/5/2016)
I would like to get into the mind-set of speakers out there. Now, as it stands I have zero-interest in presenting/speaking due to a lack of knowledge.My question is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Phil Parkin (8/4/2016)
SSIS can run procs in parallel, no problem.Or threading through PowerShell.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
SQLRNNR (8/2/2016)
Grant Fritchey (8/2/2016)
BLOB_EATER (8/2/2016)
Do you guys have any advice on how to improve my stats for my blog?Is it quality over quantity? Or should I be aiming for...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
GilaMonster (8/2/2016)
Grant Fritchey (8/2/2016)
Publish as regularly as possible. It doesn't have to be on a set schedule, but it needs to be fairly consistent. I go for 4 a month,..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 4,561 through 4,575 (of 22,227 total)