Viewing 15 posts - 1,531 through 1,545 (of 9,715 total)
I don't think I've ever seen a spill warning before I moved to SQL 2012. Now I seem to be spotting them all over the place. I really wish I...
August 15, 2016 at 8:59 am
TomThomson (8/11/2016)
Lynn Pettis (8/11/2016)
Brandie Tarvin (8/11/2016)
SQLRNNR (8/10/2016)
Brandie Tarvin (8/10/2016)
Sean Lange (8/10/2016)
Brandie Tarvin (8/10/2016)
SQLRNNR (8/9/2016)
Brandie Tarvin (8/9/2016)
I am experiencing that sinking feeling one gets when one realizes an instance of SQL...
August 12, 2016 at 7:31 am
Brandie Tarvin (8/10/2016)
Luis Cazares (8/9/2016)
Did you try increasing the max token size as suggested in here:https://msdn.microsoft.com/en-us/library/cc645913.aspx?
No. Because my Google-Fu didn't uncover this page. Thanks for the link. I'll check it...
August 12, 2016 at 5:35 am
Steve Jones - SSC Editor (8/11/2016)
S7 (8/10/2016)
August 11, 2016 at 10:27 am
A few things to consider. Does the junior DBA need some mentoring? Is this a go-getter type of person or someone who just sits around waiting for other people to...
August 11, 2016 at 8:55 am
TheSQLGuru (8/9/2016)
SQLJudo did a 30-day series on creating your own SSMS Add-in. Why don't you just build what you need (and then make a product out of it and become...
August 11, 2016 at 4:37 am
Phil Parkin (8/9/2016)
EXEC master.sys.xp_create_subdir @DatabaseDailyFolder;
If so, I think you might have to modify your code to capture the execution status of the xp...
August 11, 2016 at 4:35 am
SQLRNNR (8/10/2016)
Brandie Tarvin (8/10/2016)
Sean Lange (8/10/2016)
Brandie Tarvin (8/10/2016)
SQLRNNR (8/9/2016)
Brandie Tarvin (8/9/2016)
I am experiencing that sinking feeling one gets when one realizes an instance of SQL was installed without a sysadmin...
August 11, 2016 at 4:09 am
Sean Lange (8/10/2016)
Brandie Tarvin (8/10/2016)
SQLRNNR (8/9/2016)
Brandie Tarvin (8/9/2016)
I am experiencing that sinking feeling one gets when one realizes an instance of SQL was installed without a sysadmin account.
To be fair,...
August 10, 2016 at 12:10 pm
SQLRNNR (8/9/2016)
Brandie Tarvin (8/9/2016)
I am experiencing that sinking feeling one gets when one realizes an instance of SQL was installed without a sysadmin account.
To be fair, I don't know for...
August 10, 2016 at 11:54 am
Luis Cazares (8/9/2016)
Did you try increasing the max token size as suggested in here:https://msdn.microsoft.com/en-us/library/cc645913.aspx?
No. Because my Google-Fu didn't uncover this page. Thanks for the link. I'll check it out.
August 10, 2016 at 5:42 am
Sigh.
I am experiencing that sinking feeling one gets when one realizes an instance of SQL was installed without a sysadmin account.
To be fair, I don't know for sure that the...
August 9, 2016 at 11:32 am
TheSQLGuru (8/3/2016)
Brandie Tarvin (8/3/2016)
I appreciate the suggestion, Eric. But my hands are tied on third party software. We're not allowed to use unapproved stuff. Hence hacking SSMS Object Explorer Details...
August 9, 2016 at 9:38 am
Well, this is heartbreaking...
Poking around AdventureWorks, I get stuff like this in SQL 2008.
exec sp_executesql N'SELECT
udf.name AS [Name],
SCHEMA_NAME(udf.schema_id) AS [Schema],
''Server[@Name='' + quotename(CAST(
serverproperty(N''Servername'')
...
August 9, 2016 at 9:32 am
Phil Parkin (8/9/2016)
It's probably obvious, but I didn't see it. Which line of code is...
August 9, 2016 at 6:20 am
Viewing 15 posts - 1,531 through 1,545 (of 9,715 total)