TSQL Challenge - Table Truncation - 29 Jul 2011Commented on: 3 years ago
(July 31, 2011)
Very easy with partitioning:
ALTER DATABASE yourdb ADD FILEGROUP [fg1]
ALTER DATABASE yourdb ADD FILE ( NAME = N'fg1', FILENAME = N'C:\Program Files\Microsoft SQL...
Granting SA Rights to DevelopersCommented on: 9 years ago
(August 13, 2004)
SQL Profiler is a DBA's tools and it should not be given to developers. I agree, but sometimes i could not help for DBA because i have no rights, and she can not give me sysadmin rights. (because of...
Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More