Viewing 15 posts - 1,081 through 1,095 (of 14,953 total)
It'll really depend on what kind of locking is going on in the database.
If, for example, there's some very long process that's got a few rows locked, and you need...
August 6, 2012 at 11:29 am
Take a look at Coalesce while you're getting into this. It has advantages over IsNull, in that it can have more than 2 arguments. Plus, it is part...
August 6, 2012 at 11:24 am
john.moreno (8/6/2012)
For instance, I recently said at my workplace that a database backup created on one version of SQL Server could not be restored onto a different version of SQL...
August 6, 2012 at 11:16 am
The whole idea is to maximize bandwidth that can be used to read/write in tempdb. Keep that in mind on everything you read about it, and it'll help.
For example,...
August 6, 2012 at 11:08 am
It depends on what type of DBA you want to be. There are a lot of different flavors of "DBA".
Some DBAs just manage high-availability. That means backup and...
August 6, 2012 at 9:55 am
wendy elizabeth (8/6/2012)
August 6, 2012 at 9:46 am
The place to start with backup plans is to realize you don't need a backup plan, you need a restore plan.
Starting with an inventory is a good idea. Then...
August 6, 2012 at 9:43 am
SQLKnowItAll (8/6/2012)
GSquared (8/6/2012)
The Stuff() function can take a variable as the position.For example:
declare @Position int = 2;select stuff('mystring', 2, 0, '-');
Where are you using the variable? 🙂 I think you...
August 6, 2012 at 9:19 am
Thought of a possibility. Are you modifying the column by dropping and re-creating the table, or by using the table designer GUI, or by issuing a simple Alter Table...
August 6, 2012 at 9:13 am
I must be missing something, or this script must be missing something.
First, the primary key constraint is on a column that's not in the table definition.
Same for each of the...
August 6, 2012 at 9:11 am
QotD peer-review has been suggested a number of times. There have been threads on specifically that subject.
I think there have been some technical and/or editorial barriers on it. ...
August 6, 2012 at 9:06 am
Are you talking about something like Replication, where data will be automatically copied from one server to another? Or about auditing, where data will be compared from one server...
August 6, 2012 at 6:58 am
Dates in SQL Server aren't stored in any of those formats. They're stored as a number of days since "day 0" (1/1/1900 by default). The formatting you are...
August 6, 2012 at 6:54 am
Viewing 15 posts - 1,081 through 1,095 (of 14,953 total)