Forum Replies Created
Viewing 15 posts - 5,146 through 5,160 (of 22,224 total)
-
RE: Are the posted questions getting worse?
Sean,
Here's hoping it all works out great.
"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: Question: Migrating from SQL 2014 to Azure SQL
SQL!$@w$0ME (2/8/2016)
Grant Fritchey (2/8/2016)
What did you need the filegroup for?Thanks Grant!
The db has been designed/created to use a user defined file group as default for data and a separate index...
"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: Monitoring the resource usage of a user
I haven't done this myself, but if I were going to do it, I'd use extended events. The trick is going to be filtering by a particular user. If 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: Question: Migrating from SQL 2014 to Azure SQL
Nope. No file group support in Azure SQL Database. Azure SQL Database is a Platform as a Service (PaaS) offering for SQL Server databases. No options that require access 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: create table on partitioned database takes a long time
If you are trying to identify the longest running process, on a 2014 system, I wouldn't use Profiler (I wouldn't ever use Profiler to capture data, just consume already captured...
"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 2014 setup.exe does nothing
You must be missing the correct media. If you have the correct media, it just works.
"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?
Steve Jones - SSC Editor (2/4/2016)
I'm sure that's my presentation...where I fix Grant's code.
Ha! Love you too!
I have to go back and tune his "fixes" later so...
"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?
Grumpy DBA (2/4/2016)
In the past I worked with a couple developers (SQL and Oracle) who used Select * quite often. At every code review I would point out all..."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?
Eirikur Eiriksson (2/4/2016)
For fun (screenshot from a RedGate presentation)😎
Why do you think I'm working on that database?
Ha!
I'm pretty sure that's one of Steve's presentations.
"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: Keeping a production database and a remote database in sync
Br. Kenneth Igiri (2/1/2016)
Grant Fritchey (1/28/2016)
To get data moving both directions you're probably looking at Merge Replication. But that requires quite a bit of redesign. You could use transactional replication,..."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: Abstract: Tech Writing for Techies
Well, just remember, I'm just some guy and my opinion isn't worth much more than others. If you're happy with it, use it. Plus, I keep getting rejected on PD...
"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: BIG HELP Needed!!
What changed on the system? Something has to be different. Determine what that is and you may have your solution.
"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: Abstract: Tech Writing for Techies
Ray K (1/29/2016)
Grant Fritchey (1/28/2016)
Great topic. I'd add one more sentence to the abstract. It feels short. I'd add two or three specific techniques that you're going to teach so..."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 (1/28/2016)
Alan.B (1/28/2016)
What I hate about Azure SQL & Azure SQL Data Warehouse is the limitations, specifically the T-SQL limitations.Which ones?
I ask because, for the Azure SQLDB side, most...
"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?
BL0B_EATER (1/29/2016)
Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?Yeah, I'd love to teach...
"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 - 5,146 through 5,160 (of 22,224 total)