Viewing 15 posts - 91 through 105 (of 1,584 total)
What does the sp on SQLA do? Just a SELECT? INSERTS? ETC?
Also, what version of SQL?
March 20, 2015 at 10:31 am
Awesome! Please be sure to set the autogrowth setting to "In Megabytes", and not "In Percent", and as SQLBill mentioned, ensure the "Maximum File Size" is set to a...
March 19, 2015 at 9:02 am
If your database is full, you need to add more space. Rather than making it a manual process, simply enable the autogrowth setting to something "reasonable" (and get rid of...
March 18, 2015 at 1:53 pm
It depends. Do you have a lot of clustered/non clustered indexes?
Take a look at your "data" column on a day-to-day basis, that will give you an idea of how...
March 18, 2015 at 8:49 am
Not sure if this is something you're looking for but I recently posted a process on SSC to track these types of things. Feel free to check it out...
March 17, 2015 at 4:29 pm
How about something like this?SELECT
OBJECT_NAME(referencing_id) AS referencing_object,
referenced_entity_name
FROM
sys.sql_expression_dependencies
WHERE
referenced_database_name IS NULL
AND is_ambiguous...
March 17, 2015 at 4:20 pm
Do you mean for procedures that are called within procedures i.e ("other" procedures get executed from within a calling procedure?)
March 17, 2015 at 11:35 am
+1 sql_lock!
March 10, 2015 at 12:04 pm
You can also find out if a table is replicated by running the query below on the publisherSELECT * FROM sys.tables WHERE is_replicated = 1
March 2, 2015 at 12:16 am
You may want to look at the sp_repladdcolumn
There's some discussion on it here:
http://www.sqlservercentral.com/Forums/Topic153870-71-1.aspx
February 10, 2015 at 1:21 pm
How big is the table?
If it's not too large it would be easier to drop the article and re-add it with the new columns (or all of them). This...
February 10, 2015 at 10:57 am
Assuming you are using windows authentication and you wish to only grant READ ONLY access, this should work: USE [master]
GO
CREATE LOGIN [DOMAIN\username] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
USE [DatabaseYouAreGrantingAccessTo]
GO
CREATE USER [DOMAIN\username] ...
February 10, 2015 at 10:19 am
I'm terribly sorry Peter, I just don't know what else to offer - I'm very sorry:crazy:
February 8, 2015 at 10:31 pm
No, using this method there is no way to track the actual change made. You would need to either use a 3rd party monitoring tool or enable CDC. ...
February 3, 2015 at 8:12 am
There are many views on this, of which you can easily find via google 🙂 My personal stance (without knowing how the DB is actually used) is to size...
February 2, 2015 at 10:47 am
Viewing 15 posts - 91 through 105 (of 1,584 total)