Viewing 15 posts - 9,001 through 9,015 (of 22,219 total)
Take a look at T-SQLT[/url]. That's a unit test framework for T-SQL. You can also check out SQL Test[/url]. That's a framework that Red Gate wrote around it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 23, 2014 at 2:09 pm
Oh, if they're mapped to a single user, yeah, you're kind of stuck. There's no easy way there. You'd have to modify your structure so that instead of mapping them...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 23, 2014 at 8:08 am
Put an upper limit for SQL Server so that it doesn't take all your memory. SQL Server, out of the box, is configured to take every bit of memory it...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 23, 2014 at 7:32 am
But, SO has a very firm idea in mind, questions and answers, period. Because of this focus, they get a lot of attention, additional links from blogs, etc., which leads...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 23, 2014 at 7:30 am
If the users are coming in under different accounts, isn't the account the differentiator? I realize the roles are the same, but that's a login mapped to a role (hopefully)...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 23, 2014 at 7:22 am
Session ID > 50 is not a good way to determine system processes. Instead use a join to sys.dm_exec_sessions to use is_user_process something like this:
SELECT *
FROM ...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 23, 2014 at 5:50 am
Check the compatibility level of the database you're querying against. If it's an older version, that can prevent Intellisense from working. Other than that, ensure that it's enabled and understand...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 23, 2014 at 4:48 am
You can query sys.dm_exec_requests in combination with sys.dm_exec_sql_text to identify the query and session and then kill it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 23, 2014 at 4:44 am
I occasionally refer to CUD, Create, Update, Delete, when discussing the parts of ORM tools that I (sometimes) don't have problems with. Nothing in Bingle either. I think you may...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 23, 2014 at 4:41 am
rodjkidd (1/23/2014)
Koen Verbeeck (1/23/2014)
rodjkidd (1/23/2014)
...and told him to search the internet for videos of Grant.WHAT HAVE YOU DONE?!?
He He - I know - can we turn the internet for a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 23, 2014 at 4:36 am
Also check at sqlpass.org both for local training and free online training.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 22, 2014 at 12:44 pm
Depending on your location, I'd suggest finding the nearest user group and the nearest SQL Saturday event. Those two places will enable you to begin to network with other locals....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 22, 2014 at 10:33 am
From the sounds of things, you're not so much looking at data warehousing as you are the performance of the queries being used against the data warehouse. If so, I'd...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 22, 2014 at 9:05 am
SQLRNNR (1/22/2014)
Grant Fritchey (1/22/2014)
praneethydba (1/22/2014)
HI,I am happy to tell you, my database is up now.....
Online now.....:-)
Thanks a lot for your support...
Thanks
Praneeth
Congrats! That's great!
Now, run a backup.
No, schedule regular backups and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 22, 2014 at 9:01 am
praneethydba (1/22/2014)
HI,I am happy to tell you, my database is up now.....
Online now.....:-)
Thanks a lot for your support...
Thanks
Praneeth
Congrats! That's great!
Now, run a backup.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 22, 2014 at 8:19 am
Viewing 15 posts - 9,001 through 9,015 (of 22,219 total)