Viewing 15 posts - 11,116 through 11,130 (of 19,560 total)
Do you have other things running at the same time that may be conflicting?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2011 at 1:32 pm
Here is a starting point.
You may want to throw this into a powershell script or ssis package and return the results with servername back to a central reporting table.
Use Master
GO
SELECT...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2011 at 1:28 pm
GSquared (1/21/2011)
The For...Each loops in SSIS can specify that they are for each file. There's an option for including subfolders.
That works too;-)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2011 at 1:23 pm
For a 1-time task, the cursor is not really such a bad option.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2011 at 1:19 pm
K. Express is a different beast. Try this resource and see if it has something of use for you.
http://technet.microsoft.com/en-us/library/ms365166.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2011 at 1:13 pm
One option that comes to mind is to enumerate the folder names in that directory into an object variable and then perform a foreach loop on each of the folders...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2011 at 1:04 pm
jcrawf02 (1/21/2011)
You had lots of fun with that, didn't you,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2011 at 12:59 pm
Not a PHP expert but it looks like you haven't properly concatenated the string in this line
$check = mysql_query("SELECT * FROM users WHERE username = '$username'")or die(mysql_error());
The $username should be...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2011 at 12:58 pm
Even in the case presented in the editorial, the data was not changed - just amended. I'm not opposed to amending in a fashion where a new record is...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2011 at 12:49 pm
D.R.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2011 at 12:36 pm
Did you install reporting services and the business intelligence stuff when you installed?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2011 at 10:33 am
Are you looking at the correct reference?
You can look at the SSRS instance by clicking the connect tab in the object explorer and selecting reporting services. Then you can...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2011 at 10:02 am
Here are three sample scripts. You would need to modify the first two to have them dump into the staging table.
/* SQL 2005 */
SELECT T1.*
FROM dbo.sysdtspackages90 AS T1
INNER...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2011 at 9:55 am
lduvall (1/21/2011)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2011 at 9:50 am
Lynn Pettis (1/21/2011)
CirquedeSQLeil (1/21/2011)
Lynn Pettis (1/21/2011)
CirquedeSQLeil (1/21/2011)
Lynn Pettis (1/20/2011)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2011 at 9:47 am
Viewing 15 posts - 11,116 through 11,130 (of 19,560 total)