RubberChickenLeader
  • Member for 8 years, 3 months
  • Last seen more than a week ago
How can I change the number of @schedule_uid=N'????' to re-create a SQL Server Agent Job?
14 votes

The other option to Aaron's excellent advice is to just remove @schedule_uid, the procedure will create a new UID for the schedule. That is how I moved all the jobs from our old server to our new one ...

View answer
How can I dynamically alias columns?
7 votes

This sounds prime for a front end display solution. Query 1 would pull back your data, Query 2 would pull back the column names and in code when you build what ever structure you use to display you ...

View answer
Restore .Bak file to different Server
Accepted answer
6 votes

When you take a backup all information including the file path is included as part of the backup. As you found out if you just run restore database it will try to restore to the exact same location. ...

View answer
How to monitor load on database server
6 votes

There are a couple of things here. First performance monitoring is a subject that is very broad. When I started down the rabbit hole of performance monitoring I found Brent Ozar and Paul Randal's ...

View answer
How to store schema-less data efficiently in a relational database?
4 votes

From your sample data i actually see a schema for the table UserID | UserName | City | Birthdate If you're using a relational database with the right indexing a search on that would be very fast. ...

View answer
Changing IP address of SQL Server 2008 R2
3 votes

The only issue I see is if the server is referred to by IP address in any place (Job, Connection string, or other places). That reference will break once the IP changes. In my home lab my one of my ...

View answer
Perform admin tasks (e.g. create database, add diagram support) in SQL Server when not connected to domain
2 votes

Another solution is to create an SQL Server Log on and give it sysadmin permissions. This avoids using windows entirely for authentication. This is what the SA account on SQL Server is, a special ...

View answer
Free up disk space on sql server
1 votes

In SQL server the data and log files only grow automatically. If you deleted a lot of data there will be empty space inside the file but SQL server will not shrink the file automatically because it ...

View answer
Clustered index additional storage
1 votes

There is some space used for the upper levels of the B-tree (how much depends on how large the table is). However if you look at a Clustered index and a Non Clustered index of the same data (exact ...

View answer
how to restore .bkp file in SQL Server
1 votes

If it is a SQL Server backup file from a version earlier than 2008 or 2012 (or the same version, you can not restore a Sql Server 2012 backup file to a Sql Server 2008 instance) you can restore it to ...

View answer
No CREATE_TIMEDATE column, can I still export records inserted within last 24 hours?
Accepted answer
1 votes

In SQL Server 2005 there is no hidden column for the date something was added to the table. the best solution would be to add a new DATETIME column to the tables you are looking to export the last 24 ...

View answer
Changing the SQL Server service account - any additional considerations?
Accepted answer
1 votes

Your best bet before you change the service account would be to manually make sure all the permissions are correct. This will allow you to also document what changes you make so in the future if you ...

View answer
Is a temporary table a good solution for importing temporary data into a database
1 votes

I see 2 ways to do this, your temporary table idea or running them through one at a time. Which way to go depends on how many records we are talking about. If its 3 or 4 names at a time then running ...

View answer
Database design for excel-like data
1 votes

The problem with your question is that in databases (MSSQL Specific) data has no order. What i mean is that if you add a column to a table physically on disk that column is at the "End" of the table ...

View answer
Which of these queries is best for performance?
1 votes

With out your entire database this is a hard question to answer. What I can say is this: you can test it your self. If you use either SET STATISTICS TIME ON or use the patern of DECLARE @StartTime ...

View answer
How to copy backup files to remote share in SQL Server Agent job without AD/domain accounts involvement?
Accepted answer
1 votes

To answer the specific question of why it is failing is that the service account on your server does not have the correct permissions to access the share. I have an environment where I have 2 ...

View answer
How to update cust_id from Customer table to order table Cust_id field while inserting customer name using trigger
0 votes

The way I normally accomplish this is to have the application load the data into a staging table and not directly into the orders table. Then you have the application call a stored procedure that ...

View answer
Combine tables only if no results
0 votes

If you are using Enterprise i would look at a partitioned table. If not I would look at a partitioned view. Using a partitioned table or partitioned view would help your application by allowing the ...

View answer