Viewing 15 posts - 4,276 through 4,290 (of 13,469 total)
samalex (12/5/2012)
pchirags (12/5/2012)
http://www.mssqltips.com/sqlservertip/1311/web-based-database-administration-for-sql-server/Nice Link to go through..
Thanks
I found this earlier too, but it appears to be an outdated article since the Download URI goes to http://www.microsoft.com/en-us/download/default.aspx which isn't valid. ...
December 5, 2012 at 3:16 pm
i've got this script i posted here on SSC multiple times that seems to do a nice job for me;
for Invalid Objects, it's not like oracle, where there is a...
December 5, 2012 at 2:07 pm
well so far, i haven't been able to get a duplicate in my limited testing;
i was thinking that maybe a developer had a transaction open, went to lunch, and then...
December 5, 2012 at 2:03 pm
you can use a technique using SUM(CASE... to get subtotasl;
you'll have to construct the multiple case statements to match your descriptions, i think.
here's a prototype based on the query you...
December 5, 2012 at 12:05 pm
we use this one at our shop:
primary key and foreign key column name must contain name of the table...ie tbCity has tbCityID as it's PK, and all foreign key columns...
December 5, 2012 at 10:16 am
david take a look at http://www.mylittleadmin.com/
if that's not what you are after, I can give you a copy of a simple aspx page I slapped together a long time...
December 5, 2012 at 7:21 am
I think your trigger model needs to look more like this.
because triggers handle multiple rows in SQL server, you should never declare a variable in a trigger, because it makes...
December 5, 2012 at 7:12 am
Bhuvnesh (12/5/2012)
Lowell (12/4/2012)
HEAP tables never release the space taken by deleted rows.this is new to me ..can you give me any article reference here ?
sure!
take a look at...
December 5, 2012 at 5:25 am
it's because you have have to specify the database name in front of information_schemas, otherwise it's the current context.
i personally avoid the information_schemas, and go for the SQL views instead;
this...
December 4, 2012 at 2:25 pm
to get it to 10% of it's original size, that means deleting 90% of the data? i don't think that's what you are really asking.
besides the points above, (and compresison...
December 4, 2012 at 1:37 pm
we'd have to see the actual table structure and sample data (CREATE TABLE ...INSERT INTO)
but you could do something as easy as joining with an "exotic" join...that is not with...
December 4, 2012 at 10:52 am
well, for the SQL log, exactly where the logs go is configurable...when you first install the server, one of the options is to decide on the folders.
it defaults to a...
December 4, 2012 at 9:48 am
moh_ab1979 (12/4/2012)
Just i want to know what do it mean exactly connectivity standard ?Does it mean the way to connect the database with application like ODBC engine or ........etc
well...
December 4, 2012 at 9:39 am
its certainly possible, you'd probably want to create a linked server to the other server, and then create the view with a full four part naming convention.
CREATE VIEW
AS
SELECT ColumnList
FROM MyLinkedServer.DatabaseName.dbo.TableName
Where...
December 4, 2012 at 9:26 am
Viewing 15 posts - 4,276 through 4,290 (of 13,469 total)